Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Automatic import 200 flat files to a table in Sql

Author  Topic 

dr223
Constraint Violating Yak Guru

444 Posts

Posted - 2009-09-08 : 11:00:37
Hallo,

I have 200 flat files which I need to import a table in SQL server, is there any automated means I can use to import all these files..

Any ideas will be highly appreciated..

Thanks

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2009-09-08 : 13:13:07
You can do it with an SSIS package using a FOREACH LOOP container.

Jim

Everyday I learn something that somebody else already knew
Go to Top of Page
   

- Advertisement -