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