October 23, 2003 at 4:30 pm
Hello,
I have been having some problems with importing files into SQL Server using
DTS. I am hoping someone can help me. Every time I try to import a text file
(in 'CSV' format) the file gets loaded into my database as a new table with the
name of the original file. I am trying to load the CSV file into a table which I
created previously, but it doesn't work. To do a successful DTS import into
the proper table I am forced to convert the CSV file into an Excel file first and
then go thru the process.
Another thing I would like very much to be able to do is to concatenate (i.e.
lump together) several files during the DTS import process. In other words, it
would be great if I could take 4 or 6 source files and load them all into the
SQL Server table in one shot.
If anyone can make some useful suggestions on these 2 questions I would be
very appreciative.
Many thanks in advance!
Joe
October 27, 2003 at 8:00 am
This was removed by the editor as SPAM
October 27, 2003 at 8:46 am
You will see this behavior if you use the wizard to import data (All Tasks->Import Data).
Use DTS Designer by going to DTS Services -> New Package. Create a connection object pointing to your server. You can define the import files and specify which table you would like to import data into. Use a "Transform Data Task" to set all of this up. I always have much better luck designing DTS packages on the server, not my workstation. Use Books Online for more information.
Hope this helps,
Kathi
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply