SQL Server Performance Forum – Threads Archive

pass filename

Using SSIS foreach loop I get the files names inside a folder on the network.
How do I pass this variable i.e. file name to a stored procedure?
Thanks

---

http://www.sqlis.com/default.aspx?55 Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.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.

---

Yes, this is how I get to each filename.
Now I would like to pass the variable (Which holds the filename) to a stored procedure.
Thanks

---

]]>