February 11, 2003 at 10:59 am
Hi everyone,
I'm writing a simple DTS job to transform a table to a fixed-width text file. I go about it by creating a db connection and assigning it to the database. Then, I create a Text (destination) item and link it with the database connectiong via a transform data operation. I choose the desired table to export and then click the destination tab. When I click the define columns button, I get the pop-up which I can populate with the source fields. I hit execute, and instead of the fields showing up in the destination list, the list remains blank. If I click define columns again, MMC crashes.
I've tried using a "SELECT * FROM table" SQl statement instead of using the table drop-down (for the data source) and I've received the same results. The only way that I've been able to get any of the fields to show up in the destination list after clicking the execute button in the field definitions popup is by using a SQL statement that explicitly defines the columns that I want from the table. Even in this case, it seems like I can have any combination of fields from the table, but no more than 22 fields in total (there are 25).
Has anyone experienced this before? I have a critical deadline and this is holding me back!
BTW: I'm running SQL Server 2000 with SP3.
Any help would be most appreciated!
Regards,
Mathieu
February 11, 2003 at 12:02 pm
Is the total length of a row in the text file > 255 characters? If so, you may want to contact Microsoft's PSS. I believe there is a fix available for SP 3.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
August 19, 2004 at 9:58 am
I just encountered this problem yesterday and can attest that it is directly related to the SP3 update. I contacted microsoft tech support who confirmed it and provided the following link http://support.microsoft.com/default.aspx?kbid=821277,that solved the "regression bug" problem which is documented in: http://support.microsoft.com/default.aspx?kbid=814113.
Please note that applying the "Fix" may cause other problems, such as not being able to log in. If that occurs, the Fix for the Fix is in: http://support.microsoft.com/default.aspx?kbid=826161.
Hope thats not too confusing, but thats Microsoft (Love em or Hate em)
Kevin.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply