• 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