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