SQL Import

Baz · 12 Mar 2007 at 13:08

Easy question, not so easy answer..

I have a lot of files I wish to import into SQL Server on a regular basis, like every week. The files are CSV files, each with a different filename.

How can I create a script that will import the files, transfer the filename into a column in the table. I have already looked at the bulk import in BOL, but it's not easy to understand..

Any help is appreciated

Baz · 12 Mar 2007 at 16:05

OK, cheers, found a few webpages when searching for DTS.

Any problems, and I'll be back

Baz · 13 Mar 2007 at 14:45

Ok, trawled through lots of websites, and now I am offically confused :confused:

I have tried to create a DTS package, but I cannot see how to link them together, or how to tell it to go to another file, which it hasn't previously imported.. or take the filename, which unfortunately isn't predictable...

The next version of SQL wants Voice activation for dummies built it... 'Hey SQL, import them there files into that table.!" much easier

Baz · 14 Mar 2007 at 08:14

Cheers, I had found some tutorials online, but they were all for importing just one file.... which would take some time with the amount I have