| Author |
Topic |
|
karuna
Aged Yak Warrior
582 Posts |
 Posted - 2005-05-09 : 10:13:30
|
| I have a dts package which exports data to a text file, among others 3 columns have a varchar size of 4000 some times these columns gets truncated when the dts pushes data from table to text file. I'm searching on the pattern of truncate, If I find any I'll post it here. Else any idea why it gets truncated.Even though the column length is 4000, most of the times it doesn't hold that much still data gets truncated when writing to text file.Karunakaran___________It's better to be loved and lost, than ever to be loved... |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-05-10 : 10:33:34
|
| One thing I could able to figure out is that it gets truncated after 255 characters. In my destination file selection I dont have a fixed width, its seperated by tab still data truncated after 255 charactersAnything I missed?Karunakaran___________It's better to be loved and lost, than ever to be loved... |
 |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-05-10 : 11:11:07
|
are you using query analyzer??look at tools\options\results\Maximum Characters Per Column: 255change to desired.Corey Secret Service Agent: Mr. President, you're urinating on me.President Lyndon Johnson: I know I am. It's my prerogative. |
|
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-05-10 : 11:14:50
|
| I'm not using QA. Its DTS. While transferring to text file it truncates at 255 charactersKarunakaran___________It's better to be loved and lost, than ever to be loved... |
|
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-05-10 : 11:19:39
|
| how are you looking at the data? QA? I am suggesting that the data is not truncated, and you are only looking at a portion of the data. (aka 255 characters, the default for QA)CoreySecret Service Agent: Mr. President, you're urinating on me.President Lyndon Johnson: I know I am. It's my prerogative. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-05-10 : 11:20:25
|
| 3 columns at 4000?hmmmm....And are you sure it's a text file...not Excel?Brett8-) |
|
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-05-10 : 11:24:45
|
quote:
Originally posted by Seventhnight
how are you looking at the data? QA? I am suggesting that the data is not truncated, and you are only looking at a portion of the data. (aka 255 characters, the default for QA)CoreySecret Service Agent: Mr. President, you're urinating on me.President Lyndon Johnson: I know I am. It's my prerogative.
My bad... misread as importing not exporting. I think Bretts on the right track.CoreySecret Service Agent: Mr. President, you're urinating on me.President Lyndon Johnson: I know I am. It's my prerogative. |
|
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-05-11 : 00:30:23
|
quote:
Originally posted by X002548
3 columns at 4000?hmmmm....And are you sure it's a text file...not Excel?Brett8-)
Yes 3 columns at 4000. I know that much will not be used but client insist to keep the maximum possible length. I'm exporting to the text file.Karunakaran___________It's better to be loved and lost, than ever to be loved... |
|
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-05-11 : 02:10:04
|
| Okay...Finally I found the reason for data truncation.http://www.sqldts.com/default.aspx?297 This solved the problem.Karunakaran___________It's better to be loved and lost, than ever to be loved... |
|
|
|
|
Data gets truncated