By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,904 Members | 925 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,904 IT Pros & Developers. It's quick & easy.

SQL 2000 DTS Error: Invalid Column Length

P: 142
I created a DTS process that extract data from a table to a .txt file using fixed-delimited column type. I have 39 fields in the SQL query script. When I execute the DTS process I am getting an "Invalid Column Length" error after I execute the transformation task, but when I switch to a delimited format I am not getting the invalid column length. Is there a limitation for a fixed length format?

Oct 17 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,017
Is it possible that your fixed length is shorter then actual data in some records?
Try this on your table:

Expand|Select|Wrap|Line Numbers
  1. Select max(len(col1)), max(len(col2))........
  2. From table_name

Good Luck.
Oct 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.