Friday, February 24, 2012

Import all xml-Files from a Folder into SQL

Hello

I'm just starting with SQL and BIDS. I have created a xml-Import to SQL Server which works without any problem.

Now I like to import (daily) all xml-files of an appropriate Folder at once to the DB. The files will have different names each day.

I could not find any help in the internet to solve this problem.

Can someone give me an Idea how to import many xml-files out of the same folder to SQL?

Thanks & regards

Chaepp

The For Each Loop can do this. It is covered in Books online, or try this article-

Looping over files with the Foreach Loop
(http://www.sqlis.com/default.aspx?55)

|||

Hi DarrenSQLIS

Thank You very much for the info's. It's working perfect.....

Have a nice day

Regards

Chaepp

No comments:

Post a Comment