Post reply

SSIS 2012- Pass filename to SSIS Package

  • December 17, 2013 at 1:02 am

    #287491

    Hi,

    I have to schedule job as follows.

    Step 1. Will trigger a job on another Server by CMD. and generates .dat/.csv file with timestamp.

    Step 2. Execute SSIS Package for extracted file in Step1

    My question is, i have to pass the file name(created in Step1) to execute the SSIS package.

    Thanks,

    SP

  • December 17, 2013 at 1:11 am

    #1673969

    Can't you put the generated files in specific folder and use a for each loop in the SSIS package to pick up the files?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 17, 2013 at 5:04 am

    #1674005

    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......

  • December 17, 2013 at 5:15 am

    #1674008

    http://technet.microsoft.com/en-us/library/ff877990.aspx

    http://technet.microsoft.com/en-us/library/ff878152.aspx

    These helped from executing SSIS with parameter from SSIS Engine.....

    Can i use same commands for scheduling in SQL Agent...

    Will those "catalog." directly use in Database Engine?

  • December 17, 2013 at 5:29 am

    #1674017

    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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply