September 8, 2004 at 10:20 am
Hi all, I am suing dts to extract data from a sql 2000 database via a stored procedure and output it to a text file. After estabilishing a connection to the server and the text file I select the transform task and select the source and then the destination(which is the text file).
In the transform task properties I check the radio button that is labled SQL Query and enter the exec (my stored procedure), when I click on the destination tab I get the define columns dialog which shows me the columns that will be created, when I click on execute and the dialog closes there are no columns defined.
If I modify the sp and only select one column it seem to work, but if I add additional columns sometimes it will work and other times it will not work.
I have several other text files that work correctly. the problem is with only two out of 20 text files that I am working with.
I have tried everything I can think of including checking for carriage returns and checking for null.
Any help is greatly appreciated.
Thanks
Gary
September 8, 2004 at 12:40 pm
Hi all, I found out what the prob is. It is a bug in SQL 2000 sp3. There is a hot fix for it at http://support.microsoft.com/default.aspx?kbid=826161
Gary
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply