call a separate dataflow task accordingly | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

call a separate dataflow task accordingly

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

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.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |