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

    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.
  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.
    Thanks

Share This Page