importing text files question

[denis60]

Hi!

I did a dts task importing 1 file to a table with the text file souce connection, but how to import multi text files in 1 table. I tried with the execute process task (with a dos batch) copy append to 1 file. It work fine but i don't know how to return code to validate.

Help please!

 

[flora9090]

Hi,

Not very sure what you want to validate.
Normally, I run store procedure ( sql query) to do loading validation.

Flora

 

[cmmsi]

At least one of these is a little old, but I always start people here for DTS:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/dts_overview.asp

It is a great overview on what you can do. While you are there, open Enterprise Manager, right click on Data Transformation Services and select New Package, then go to:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_addf_ax_1qud.asp

for more.

Best of luck.

 

[denis60]

To flora9090
What i mean is: i receive (sql server) many text file in csv format from a linux server. Those files have to be push in 1 table. I'm new with store procedure could you tell me more.

Thanks also to cmmsi for your help.