Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-10 : 09:32:24
|
nilesh writes "I am trying to create a DTS package. This package will load data from a comma seperated ascii file. one of the fields in this file is long text field with multiple lines of data. The string/text identifier is "(double quote sign). So the example data would be something like,
"this is sample dat
a which is split into multiple
lines and very long, may be more than 2000 characters long
so it goes and goes and ...."
My problem is when sql server runs the package, it truncates the data length to somewhere around 250 characters. I am not sure about the length as there are newline etc characters are invloved. How do get DTS to insert all 2000 characters instead of truncating it...?
I appreciate your responses.
Nilesh" |
|
|
|
|
|
importing long text data from a text file and other questions