SQL 2000 DTS tool - 256 char limit?

**Jim** · Aug 1 '08, 08:55 AM

Re: SQL 2000 DTS tool - 256 char limit?

On 2008-08-01, Jim <jim@magrathea. plus.comwrote:

I'm using the DTS tool (generally called "Import and Export Data", two cogs)
to export a table to a text file. However, it seems to be truncating the
char(1024), in that it's only outputting the first 256 chars. Is this a
limit of the tool, or am I just doing something wrong? It's early and the
coffee hasn't kicked in yet...
>
I'm not altering any settings/transformations etc., it should be just a text
version of the table, warts and all.
>
Interestingly, Queary Analyser does the same thing in that it only returns
the first 256chars. I can understand that in QA, but in DTS it just seems
odd.

Okay, sorry, should have Googled first - short answer is "yes, it's a limit
of DTS". Solution is to use BCP instead.

Now I just need to get my head around BCP. Wish me luck.

Jim
--
http://www.ursaMinorBeta.co.uk http://twitter.com/GreyAreaUK

"Sometimes when I talk to a Windows person about using a Mac,
I feel like I'm explaining Van Halen to a horse." Merlin Mann

SQL 2000 DTS tool - 256 char limit?

SQL 2000 DTS tool - 256 char limit?

Comment