Post reply

Excecute process Task for executing a bat file

  • September 5, 2014 at 2:52 am

    #289754

    I have a exec file which takes multiple input variables and produce output in the form of Table.

    Can I achieve this through Excecute process Task in SSIS Package.

    Thanks & Regards,

    Viji

  • September 5, 2014 at 2:58 am

    #1743444

    vijayalakshmii.venkatesh (9/5/2014)

    I have a exec file which takes multiple input variables and produce output in the form of Table.

    Can I achieve this through Excecute process Task in SSIS Package.

    Thanks & Regards,

    Viji

    Can a .bat file be executed by an Execute Process task? Yes.

    Can an Execute Process task be used to accept a table as a returned resultset? Not in any way I can think of.

  • September 5, 2014 at 6:02 am

    #1743487

    Hi

    I am running a bat file which executes runnable jar

    My bat file:

    @echo off

    ECHO Hello, world! This is my test BAT file!

    java -jar E:\DH\Work\Simmetrics.jar one two

    Here one and two are variables

    now I am using Execute Process Task to run this bat file

    I want to pass this one and two variables from Standard input variable

    and wanted to know the difference btw Arguments and Standard input variable

    Thanks & Regards,

    Viji

  • September 7, 2014 at 10:50 pm

    #1743758

    Hi

    Anybody can help me out

  • September 7, 2014 at 10:50 pm

    #1743759

    Hi

    Anybody can help me out

    thanks

    viji

  • September 7, 2014 at 11:49 pm

    #1743762

    Does your bat file actually contain a call like this?

    [font="Courier New"]java -jar E:\DH\Work\Simmetrics.jar %1 %2[/font]

    If so, then %1 and %2 will take their values from parameters passed to the bat script on the command-line and you can pass those to the bat script when calling it from an Execute Process Task. You would pass those using the Arguments property of the Task and you can use an Expression to define the value of the Arguments property taken from your Variable values.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • September 9, 2014 at 12:16 am

    #1744005

    Thanks it worked fine..

    but here instead of passing variable I wanted to pass the Result set Object in the argument .Is that possible or Can we pass via standard Input variable and access in the .bat file?

    Thanks & Regards,

    Viji

  • September 9, 2014 at 6:47 am

    #1744092

    vijayalakshmii.venkatesh (9/9/2014)

    Thanks it worked fine..

    but here instead of passing variable I wanted to pass the Result set Object in the argument .Is that possible or Can we pass via standard Input variable and access in the .bat file?

    Thanks & Regards,

    Viji

    No, you cannot pass a resultset through the command line to a bat script, just a series of scalar values.

    It is starting to sound like you're trying to integrate SSIS and Java which would be analog to trying to mix oil and water.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 8 posts - 1 through 8 (of 8 total)

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