August 29, 2001 at 10:42 am
I am writing a DTS package in SQL 2000 SP1 running Advanced Server SP2.
I am trying to output the results from a sql query to a csv file. When I preview the results of the sql statement from inside the 'tranform data task' window all looks fine, but when the package is executed one field (a large varchar) get truncated after a couple of hundred characters, and the rest of the fields after are written to the file.
I have checked the defined column for the output file and that can handle it.
Any ideas?
Steven
September 5, 2001 at 6:52 am
Sorted. I needed to check the 'binary' column in the defined destination column
Steven
September 5, 2001 at 7:56 pm
Thanks for the follow up! Sorry we didnt get you an answer this time, but please keep us in mind for next time.
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply