pass data from file into sp | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

pass data from file into sp

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 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