SQL Server Performance Forum – Threads Archive

pass data from file into sp

Hi,
Using SSIS 2005 how is it possible to loop through a folder on the network, look at each file, pass the data inside each file as a string into a stored procedure.
Thanks

---

http://sqlteam.com/forums/topic.asp?TOPIC_ID=85966 Madhivanan Failing to plan is Planning to fail

---

hi,
That does not show mw how to get the contents of an xml file into a string and pass it to a stored procedure.
Thanks

---

i don’t know if you can do that in ssis but you can pass a file name to a sproc that reads the file in the xml datatype:
http://weblogs.sqlteam.com/mladenp/archive/2007/06/18/60235.aspx _______________________________________________
Causing trouble since 1980
blog:http://weblogs.sqlteam.com/mladenp

---

]]>