SQL Server Performance Forum – Threads Archive
pass data from file into spHi,
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.
http://sqlteam.com/forums/topic.asp?TOPIC_ID=85966 Madhivanan Failing to plan is Planning to fail
That does not show mw how to get the contents of an xml file into a string and pass it to a stored procedure.
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:
Causing trouble since 1980