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-02-28 : 09:32:11
|
| Martin writes "We are using SQL Server 7 Standard (no service packs). I need to repeatedly import a CSV text file into a table with a set number of columns. The text file name and directory is static, but the file gets overwritten. The number of columns used up in the table depends on the number of CSVs in a row in the text file. It could be different every time up to the total number of columns in the table. I am using a DTS package to map these transformations but get errors if the number of columns to transform are different from the last time the package was run. Is there a way to dynamically change/recreate these transformations?" |
|
|
|
|
|
Dynamically recreating DTS transformations