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

On 2008-08-01, Jim <jim@magrathea.plus.com> wrote:
> 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