Home Forums Article Discussions Article Discussions by Author Discuss content posted by Orlando Colamatteo Using the Script Task in SSIS to Process Data Files When They Arrive RE: Using the Script Task in SSIS to Process Data Files When They Arrive

  • October 25, 2012 at 4:36 am

    #1552609

    Yes SQL 2008 R2 SSIS can support this

    Looking under "Control Flow tools"

    you will find in order of use in this package

    1. Script Task

    2. File system Task

    3. Execute SQL Task (just truncate the staging table with an sql statement)

    4. Data flow Task

    5. File System Task

    that should do it