'Invalid Pointer' error in DTS

[jazerr]

I am executing a Package from DTS that just runs a fairly basic query, and exports to a fixed width text file.

On execution all tasks complete successfully, with the excepion of the last one, which is the actual export to text. It returns 'Invalid Pointer' I have rebuilt the Transform Data task and tested each pointer by hand. Each gives the same (so helpful) error. I checked Microsoft Newsgroups and got some not so helpful advice.

help?!?!?

 

[aalmeida]

When I had an Error like that The Problem was in the Text File Definition, either a data type was not compatible between Database and Text File or Columns Size or Column Count did not match.
Are you using a Format File? the problem could be there also. AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"