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.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2007-07-04 : 11:13:04
|
| I have created a stored procedure to handle xml data.One of the inputs to this procedure is xmldata which is basically the contents of the xml in a file.Now I would like to create a SSIS package that takes the xml files from the network and uses this SP.Should I have a file system task inside a for loop container?How do I get started on this please?Thanks |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2007-07-04 : 11:41:42
|
| Hi,I currently have a .net code which loops through a folder on the network and picks up each .xml file and passes the xml data as varchar(max) to a stored procedure (SP). The SP pulls the appropriate data from the xml and places them inside different tables appropriately.Now I would like to come away from the .net code and have a SSIS package instead.Thanks |
 |
|
|
|
|
|
import xml files