call a separate dataflow task accordingly | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
call a separate dataflow task accordinglyHi,
USing the script task I can get the name of the file being processed and pass it on to a variable.
How is it possible to start a separate task based on the name of the file?
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
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.