Post reply

Pass parameter while executing SSIS

  • December 18, 2013 at 11:51 pm

    #301484

    HI all,

    I have a scenario in which I need to execute the Stored Procedure which required input parameters.

    e.g. usp_TestData ?,?

    I have created user variables in package itself and done parameter mapping in EXECUTE SQL Task

    But how can I pass values to those variables at the time to package execution..

    Please suggest

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • December 19, 2013 at 12:48 am

    #1674719

    Two ways come to mind. Configuration for the variables, or run time settings when you call the SSIS executable via the command line. If you google up SSIS command line, you'll find a number of blogs that explain the methodology.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • December 19, 2013 at 12:59 am

    #1674724

    kapil_kk (12/18/2013)

    HI all,

    I have a scenario in which I need to execute the Stored Procedure which required input parameters.

    e.g. usp_TestData ?,?

    I have created user variables in package itself and done parameter mapping in EXECUTE SQL Task

    But how can I pass values to those variables at the time to package execution..

    Please suggest

    Which version of SSIS?

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

  • December 19, 2013 at 2:13 am

    #1674734

    Koen Verbeeck (12/19/2013)

    kapil_kk (12/18/2013)

    HI all,

    I have a scenario in which I need to execute the Stored Procedure which required input parameters.

    e.g. usp_TestData ?,?

    I have created user variables in package itself and done parameter mapping in EXECUTE SQL Task

    But how can I pass values to those variables at the time to package execution..

    Please suggest

    Which version of SSIS?

    2012

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • December 19, 2013 at 2:14 am

    #1674735

    Evil Kraig F (12/19/2013)

    Two ways come to mind. Configuration for the variables, or run time settings when you call the SSIS executable via the command line. If you google up SSIS command line, you'll find a number of blogs that explain the methodology.

    how to do with configuration of the variable?

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • December 19, 2013 at 2:34 am

    #1674739

    kapil_kk (12/19/2013)

    Koen Verbeeck (12/19/2013)

    kapil_kk (12/18/2013)

    HI all,

    I have a scenario in which I need to execute the Stored Procedure which required input parameters.

    e.g. usp_TestData ?,?

    I have created user variables in package itself and done parameter mapping in EXECUTE SQL Task

    But how can I pass values to those variables at the time to package execution..

    Please suggest

    Which version of SSIS?

    2012

    Use package parameters. You can start a package with a stored procedure and pass values to those parameters.

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

  • December 19, 2013 at 2:47 am

    #1674745

    Koen Verbeeck (12/19/2013)

    kapil_kk (12/19/2013)

    Koen Verbeeck (12/19/2013)

    kapil_kk (12/18/2013)

    HI all,

    I have a scenario in which I need to execute the Stored Procedure which required input parameters.

    e.g. usp_TestData ?,?

    I have created user variables in package itself and done parameter mapping in EXECUTE SQL Task

    But how can I pass values to those variables at the time to package execution..

    Please suggest

    Which version of SSIS?

    2012

    Use package parameters. You can start a package with a stored procedure and pass values to those parameters.

    Not understand....

    if you can tell me a link about that then it will be very helpful for me...

    Thanks

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • December 19, 2013 at 3:42 am

    #1674751

    kapil_kk (12/19/2013)

    Koen Verbeeck (12/19/2013)

    kapil_kk (12/19/2013)

    Koen Verbeeck (12/19/2013)

    kapil_kk (12/18/2013)

    HI all,

    I have a scenario in which I need to execute the Stored Procedure which required input parameters.

    e.g. usp_TestData ?,?

    I have created user variables in package itself and done parameter mapping in EXECUTE SQL Task

    But how can I pass values to those variables at the time to package execution..

    Please suggest

    Which version of SSIS?

    2012

    Use package parameters. You can start a package with a stored procedure and pass values to those parameters.

    Not understand....

    if you can tell me a link about that then it will be very helpful for me...

    Thanks

    check the following link http://technet.microsoft.com/en-us/library/hh213296.aspx

  • December 19, 2013 at 3:42 am

    #1674752

    kapil_kk (12/19/2013)

    Koen Verbeeck (12/19/2013)

    kapil_kk (12/19/2013)

    Koen Verbeeck (12/19/2013)

    kapil_kk (12/18/2013)

    HI all,

    I have a scenario in which I need to execute the Stored Procedure which required input parameters.

    e.g. usp_TestData ?,?

    I have created user variables in package itself and done parameter mapping in EXECUTE SQL Task

    But how can I pass values to those variables at the time to package execution..

    Please suggest

    Which version of SSIS?

    2012

    Use package parameters. You can start a package with a stored procedure and pass values to those parameters.

    Not understand....

    if you can tell me a link about that then it will be very helpful for me...

    Thanks

    Did you try googling for SSIS 2012 parameters?

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

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

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