DTS - Invalid Pointer

How can I debug this issue since the SP works ok but when it tries to send out to a text file (using the Text Destination) I gety this?I have tried this also and sometimes get the same results. Do we have to create the file beforehand in Notepad with no content? Does it have to be deleted each time before running the package to force the package to create it each time? Do we need to create a share on the drive and use a UNC name to the file? I tried logging in from another server and running the package but this did not work this time. It has worked other times. HELP!!!

DTS - Invalid Pointer

How can I debug this issue since the SP works ok but when it tries to send out to a text file (using the Text Destination) I gety this?I have tried this also and sometimes get the same results. Do we have to create the file beforehand in Notepad with no content? Does it have to be deleted each time before running the package to force the package to create it each time? Do we need to create a share on the drive and use a UNC name to the file? I tried logging in from another server and running the package but this did not work this time. It has worked other times. HELP!!!

DTL job error log details -- sql server 2000

Hi
In job history for a DTS job I get percent complete and not futher details
when the job fails. There is no log written anywhere.
How to debug such issues?
Tks
MangeshYou can try by clicking 'Show Step details' in top right corner of the job
history section. That will show you step wise details of the result
execution. As far as logging is concerned, you can log each step's details in
a directory of your choice. This can be done while you are creating the job
steps.
ReportFAQGuy
"Mangesh Deshpande" wrote:
> Hi
> In job history for a DTS job I get percent complete and not futher details
> when the job fails. There is no log written anywhere.
> How to debug such issues?
> Tks
> Mangesh