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 |
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
 Posted - 2007-06-19 : 15:57:52
|
| I have a customer with 2000+ clients, each sending a file with between 1 and 25 comma-delimited columns. Short of creating 25 separate DTS packages, is there a way to fiddle with the DTS settings to get it to load a file into the destination table and substitute NULL values for any short columns? Something with the carriage-return line-feed settings, maybe?e4 d5 xd5 Nf6 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-19 : 16:26:58
|
| Possible if those columns allow null value. |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-06-19 : 18:23:46
|
| Columns do allow nulls. What settings are required?e4 d5 xd5 Nf6 |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-20 : 11:27:05
|
| Then you need match columns in transformation page. |
|
|
|
|
|
|
DTS with unknown number of columns.