Home Forums SQL Server 2008 SQL Server 2008 - General SSIS loop through file names defined in database table and apply File System task to each RE: SSIS loop through file names defined in database table and apply File System task to each

  • August 20, 2012 at 12:01 pm

    #1527769

    Yes and this is where I probably do not have things set correctly from the beginning.

    I have created an Object Data Type variable for the package calleld vFileName with a value of "System.Object".

    Under Parameter Mapping in the Execute SQL Task Editor I have added User::vFileName with a direction of Input, Data Type of VARCHAR Parameter Name of 0 and Parameter size of 1000.

    I do not know if this is set up correctly and how to apply it next in the Foreach loop container.