locked
calling ssis package from informatica RRS feed

  • Question

  • Since informatica not supporting muliti byte fixed width flat files we are implementing this component in SSIS. We have tested approach we are able to read/write fixed width multi byte files without any issues but we have some integration challenges.

     

    While we load fixed width multi byte file to table We have to call this SSIS package from informatica session with file name as parameter (Since filename is dynamic for every run) We need help here to pass source file name to SSIS package.

    We need your help here

    Calling this SSIS package in informatica with parameters.

     

     

     

    While creating multi byte fixed width file also to give target file name at run time. ( We have to derive target file name during run time).

    Wednesday, June 16, 2010 5:25 AM

Answers

  • Since informatica not supporting muliti byte fixed width flat files we are implementing this component in SSIS. We have tested approach we are able to read/write fixed width multi byte files without any issues but we have some integration challenges.

     

    While we load fixed width multi byte file to table We have to call this SSIS package from informatica session with file name as parameter (Since filename is dynamic for every run) We need help here to pass source file name to SSIS package.

    We need your help here

    Calling this SSIS package in informatica with parameters.

     

     

     

     

    While creating multi byte fixed width file also to give target file name at run time. ( We have to derive target file name during run time).


    can informatica call windows executables?  if so, then dtexec.exe can be called to execute the package.

    hth


    Duane Douglas, MCAD, MCITP | http://www.ssisbi.com | Please mark the post(s) that answered your question.

    SSIS Business Intelligence

    • Proposed as answer by Duane Douglas Wednesday, June 16, 2010 5:55 AM
    • Marked as answer by Bob Bojanic Monday, June 21, 2010 5:33 PM
    Wednesday, June 16, 2010 5:55 AM