pass filename | SQL Server Performance Forums

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 Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
@ 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.