anand_vanam (7/10/2010)
1. I am running the SSIS package using SQL agent job. (but I want to run many jobs at the same time which calls the same SSIS package, but the configuration file values should be changed)2. Every time the source file name is different. (it will have _timestamp)
I want to include flat file name and Destination table name (predefined) using configuration file.
1. Can't, Agent will run a SINGLE instance of a job at a time.
2. The package needs to be smart enough to pick this out.
You might look at:
http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70346/
CEWII