Import data from multiple csv files simultaneously??

[MrPeds]

Hi,

I have a number of .csv files all in the same format that I want to obtain data from and insert into a single table.

these files contain historical data whcih i want to insert into my fact table.

is there any quick way of looping through each file in turn (they are all in the same directory) and then inserting the data into the table?

I cant stand the thought of doing each one separately!

Thanks,

MrPeds.

 

[JayKusch]

Are they all the same file layout??? Same number of fields, delimited the same and such. IF SO ...

just run a DOS Command to copy all the into one big file as in ...

COPY *.txt to ALL.txt

and then import.

Thanks

J. Kusch

 

[JayKusch]

If you need to do this in your dts package, create and Execute SQL task and enter the code of ...

EXEC master..xp_cmdshell 'COPY C:\MyDir\*.txt C:\MyDir\All.txt'

Thanks

J. Kusch