Post reply

Executing Exe in C# using SSIS Execute Process Task

  • May 18, 2016 at 12:59 pm

    #307831

    Hi

    I have a exe that i am calling from SSIS execute Process Task.

    Inside exe there is logic that i want to control by passing 2 parameters "DaysFrom" and "DaysTo".

    I Created 2 Project parameters in SSIS as "DaysFrom" and "DaysTo" which i want to pass from SSIS Execute Process Task to the C# exe but having problem setting up this.

    how can we configure this scenario ?

    Any help will be greatly appreciate.

    Thanks

  • May 18, 2016 at 1:20 pm

    #1880011

    since you compiled to an executable, you need to process the command line arguments in the c# app; did you configure it to do that yet?

    what i'm thinking is that your SSIS has no way to pass the parameters to your executable yet.

    here's the first search item i found on c# command line args,

    https://msdn.microsoft.com/en-us/library/cb20e19t.aspx

    from there , you could call your executable via SSIS to get the parameters, but a job step of type Operating System (CmdExec) might also be an option.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 18, 2016 at 6:38 pm

    #1880069

    adhikari707 (5/18/2016)

    I have a exe that i am calling from SSIS execute Process Task.

    Inside exe there is logic that i want to control by passing 2 parameters "DaysFrom" and "DaysTo".

    Curious... what does the EXE actually do?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • May 19, 2016 at 9:16 am

    #1880278

    Thanks for the hint i will look into this.

  • May 19, 2016 at 9:18 am

    #1880279

    Exe pulls connect to exchange server and pull all the appointments setup for specific outlook groups and insert data into SQL table.

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

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