SQL Server Performance Forum – Threads Archive

import xml files

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

---

See under updated books online for SQL 2005 – ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/5d5be54c-2b7e-4957-9193-c5ea5c5d6d15.htm for XML Source topoic. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

you can write SP to import data . you can include the sp in SSIS http://weblogs.sqlteam.com/mladenp/archive/2007/06/18/60235.aspx I also have question why you want to use SSIS. you can do this from T-SQL. is there any specific requirment for this —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

---

]]>