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 |
|
john.burns
Posting Yak Master
100 Posts |
 Posted - 2007-07-05 : 12:58:15
|
| hi all,While importing a tab delimited file.. it seems ssis interprets the incoming col as 50 chars in length eventhough it is far smaller. any ideas how this could be??any help would be appreciated. |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-07-05 : 14:45:59
|
| Do you have the properties of the "Flat File Source" correctly? Format must be set to "Delimited"Header Row delimiter must be set to {t}---"Try not to become a man of success but rather try to become a man of value." |
 |
|
|
tmitch
Yak Posting Veteran
60 Posts |
Posted - 2007-07-16 : 23:14:12
|
| You might also check your data file to verify that there are no extraneous whitespace characters. I've run into data files from proprietary systems that drop spaces and other whitespace characters into data fields. |
|
|
|
|
|
|
Importing a tab delimited file