Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
pass variable value from sql server job agent

Answered pass variable value from sql server job agent

  • Monday, March 04, 2013 8:09 PM
     
     
    Sign In to Vote
    0

    hi,

    how cna i pass my variable value in SSIS  from sql server job agent,

    or i need to call from ssis from stored proc and and pass variable value from that sp

    need help

     

All Replies

  • Monday, March 04, 2013 8:20 PM
    Moderator
     
     
    Sign In to Vote
    0

    What are you needing to pass the value to?  You have posted you want to pass the variable from an SSIS job to another package, another job?  There are several methods to do this, but more specific details are required.

    David Dye My Blog

     
  • Tuesday, March 05, 2013 1:15 AM
     
     
    Sign In to Vote
    0

    Hello,

    Please refer the below post to see how variable values can be set from SQL Agent job

    Variable Value from SQl Agent Job

    Regards, Dinesh

     
  • Tuesday, March 05, 2013 7:11 AM
     
     Answered
    Sign In to Vote
    0

    Hi,

    Your question is bit vague, what you actually want to do DO you want to pass variable parameter in SSIS package through job ?

    Use package configuration, there are several ways to do that

    1. As Dinesh Menon suggested but that is not efficient way as you have change the job script again and again if you want to pass the different values of that variable.

    2. Use XML File pass the variables you don't need to touch the job or package just change the value inXML File.

    3. SQL Server configuration.

    Please mark it as helpful if it helps.

    Thanks

    Sumit