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.
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