October 26, 2001 at 3:56 pm
When I use DTS to export data from a table in SQL Server 7 on NT 4 to a text file, only 255 bytes of each record is transferred and displayed when i view the text file. The table has the ff: design
Col1 Char 256
However, when the table is queried with Query analyzer, it shows all the 256 bytes. I'm using DTS because I need to schedule the export.
Any help would be appreciated.
Thanks.
October 26, 2001 at 4:12 pm
October 28, 2001 at 12:01 pm
DTS on SQL Server 7 with SP2
October 29, 2001 at 6:57 am
I just found out that this is a bug, tried the workaround and it works fine for me. See Q247527.
Thanks.
October 29, 2001 at 10:21 am
October 30, 2001 at 12:20 am
the answear to Bummi
Inthe data transform task properties
on the destination tab jast press
Define Columns and check the Binary Check box
on each long text fields.
October 30, 2001 at 12:33 pm
There is no "define columns" on the destination tab. There is a "create" button that allows you to define a table.
the problem, however, is in defining the transformations. There is no location in the designer to define the "source" columns.
Steve Jones
October 30, 2001 at 12:47 pm
Check that.
On the options tab, uncheck the v7.0 format button and your source columns should appear.
Steve Jones
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply