Importing CSV FIles

[B827]

There are probably several answers to this question but as I am unsure of what to look for I can't find anything suitable.

Having converted a couple of MS Access databases to run on SQL Server I have been given the job of setting something up in SQL Server. The key part of this will be to load two csv files with identical formats into two tables then move the csv files to an archive area. The files will contain over 100,000 lines on most occasions. I am looking for an efficient method of loading. Once loaded I will move the data into different table and clear the load table ready for the next import.

Any help would be gratefully received.


Sandy

 

[dhulbert]

Have you used the Data Transformation Services, if not that would be worth a look at.

 

[B827]

Thank you dhulbert I'll look at that.

Sandy

 

[B827]

dhulbert, I have had a brief look at DTS which looks like it would do what we want. However it transpires that the file names will include the date and be in the form of

abc_DDMMYYYY.csv

can I use the DTS and programmatically set the file name each day. Alternatively can I set it up to check the file names in a folder?

Many thanks and sorry if these are simple questions to which everyone knows the answer.


Sandy