SQL Server Performance

call a separate dataflow task accordingly

Discussion in 'SQL Server 2008 Integration Services' started by arkiboys, Oct 23, 2009.

  1. arkiboys Member

    Hi,
    USing the script task I can get the name of the file being processed and pass it on to a variable.
    Question:
    How is it possible to start a separate task based on the name of the file?
    i.e.
    File being processed:
    if it is "file1.csv" then execute the dataflow task 1
    if it is "file2.csv" then execute the dataflow task 2
    if it is "file3.csv" then execute the dataflow task 3
    ...
    Thanks
    arkiboys, Oct 23, 2009
    #2

  2. satya Moderator

    By Calling a file system task in data flow (calling a control flow task from data flow task)
    See BOL System.IO.File operations in the PostExecute() method of the script component.
    satya, Oct 26, 2009
    #3

Share This Page