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 |
|
jeremy
Starting Member
3 Posts |
 Posted - 2000-12-29 : 09:37:13
|
| I need to be able to import multiple text files from a specific directory with a specific extention. I am using the FSO to get the list of files and then executing the package. The problem is that each text file has up to 20 columns, but not necessarily all the columns. The text file contains the column names on the first row. Is there anyway to have one DTS package that will import the text file into an existing table that has the same column names or into a new table. I think my problem lies in changing the transformation characteristics on the fly. Any ideas? |
|
|
|
|
|
import multiple text files with DTS