June 24, 2003 at 2:46 am
I am trying to use DTS to export data from two databases using a sql query, to a text file. It works as expected, except for text *and* varchar columns which hold information which is longer than 255 characters -- DTS seems to truncate these columns after 255 characters. It doesn't matter if I use a Copy or an ActiveX-transfer. Under the folder "Destination" for "Data Transformation Properties" the "Size" information is correct (e.g. 8000).
If I use the same query with SQL Query Analyzer or from inside an ASP page (which exports to a text file (the web server is not the same computer as the SQL server)) it works fine!
What is the problem? I am using SQL Server 7.
June 24, 2003 at 6:37 am
I found the answer myself: http://support.microsoft.com/default.aspx?scid=kb;en-us;247527.
June 25, 2003 at 6:15 am
http://support.microsoft.com/default.aspx?scid=kb;en-us;247527
(you added a period)
June 25, 2003 at 7:29 am
I believe that was fixed in a service pack. I would suggest not using the work-arounds and just test and load the sp. It is necessary for protecting your system.
Joe Johnson
NETDIO,LLC.
June 26, 2003 at 5:46 am
If I understand it correctly there is no service pack which fix this bug for SQL Server 7.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply