SQL Server Performance

pass data from file into sp

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

  1. fmardani New Member

    Hi,
    Using SSIS 2005 how is it possible to loop through a folder on the network, look at each file, pass the data inside each file as a string into a stored procedure.
    Thanks
  2. Madhivanan Moderator

    http://sqlteam.com/forums/topic.asp?TOPIC_ID=85966

    Madhivanan

    Failing to plan is Planning to fail
  3. fmardani New Member

    hi,
    That does not show mw how to get the contents of an xml file into a string and pass it to a stored procedure.
    Thanks
  4. spirit1 New Member

Share This Page