Post reply

Run Exe with different arguments values SSIS

  • May 1, 2017 at 1:27 pm

    #323264

    I have to execute an C# exe from SSIS package. The exe takes one parameter has one argument (JobType).
    There are two different Sql jobs I want to run at different times using the same exe but the argument value
    (JobType =1 For Job1
    JobType= 2 for job 2)

    How can I do this with SSIS.I am using Sql server 2012 and project deployment model.

    Thanks

  • May 1, 2017 at 1:37 pm

    #1940599

    happy55 - Monday, May 1, 2017 1:27 PM

    I have to execute an C# exe from SSIS package. The exe takes one parameter has one argument (JobType).
    There are two different Sql jobs I want to run at different times using the same exe but the argument value
    (JobType =1 For Job1
    JobType= 2 for job 2)

    How can I do this with SSIS.I am using Sql server 2012 and project deployment model.

    Thanks

    Make JobType a parameter in the SSIS package and redeploy.
    Pass JobType to the package as a parameter, whose value is defined in the SQL Agent job itself.
    https://www.sqlservercentral.com/Forums/Uploads/Images/e3f34955-19cd-4b8e-8e9c-538e.JPG

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • May 3, 2017 at 12:57 pm

    #1940969

    Thanks that works.

Viewing 3 posts - 1 through 2 (of 2 total)

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