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