Pulivarthi Sasidhar (12/17/2013)
Thanks for Info...But in mycase, the Job generates Single file only as Filename_YYMMDD_HHMMSS.csv
How my SSIS package read this file as YYMMDD_HHMMSS[ This will differ at the time of generatio and at the time of reading by SSIS]......If passing Filename as parameter to SSIS package , i can proceed with implementation.
I am looking for passing Filename as parameter to SSIS Package, based on which SSIS will import data......
Use a wildcard in your for each loop: Filename_*.csv
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP