Using DTS to import mulitple files simultaneously

[phzero]

Hi all,

I know how to use the DTS service in SQL Server 7.0 However, I'm needing to import quite a few files (flat) into my SQL table. Is there a way to select mulitple files, or better still, all the files in a particular directory and import them all at once using DTS.
Any replies will be appreciated.
Thanks all.

 

[jshanoo]

u r not specifying which database to where.

*** Even the Best, did the Bad and Made the Best ***

John Philip

 

[phzero]

Hi,

Im wanting to import the data from a flat (text) file into a SQL table using DTS in SQL Server 7.0

 

[jshanoo]

Copy teh txt files into one folder
create a dsn using Microosft Text Driver pointing to teh text files folder
*** Even the Best, did the Bad and Made the Best ***

John Philip

 

[phzero]

Hi,

jshanoo, all I can say that you're a bloody genius. Thanks a lot to you and thanks to eveyone else who were so kind to respond to this request. Have a great day, I'm sure I will.
Cheers,