sql server dts: import xml files -- sql server dts

import xml files

farshad
7/4/2007 8:16:01 AM

sql server dts:

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 sql server 2005 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

RE: import xml files

Dan
7/6/2007 10:46:01 AM

SSIS has a native XML data source. Is there a reason you don't want to use it?

You could then separate the shredding of the XML from the work being done on
the data it provides. In other words, let SSIS do the heavy lifting with
reading the XML and use the stored proc to handle the data.

It would seem like a lot less maintenance to me.

Dan

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.