SQL Server Performance

pass filename

Discussion in 'SQL Server 2005 Integration Services' started by fmardani, Jul 11, 2007.

  1. fmardani New Member

    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?
  2. satya Moderator


    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.
  3. fmardani New Member

    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.

Share This Page