Solved

Pass variables to SSIS package

Posted on 2011-03-10
4
593 Views
Last Modified: 2012-06-21
I have created a SSIS package and schedule it with SQL agent. However, any idea how to change the variables defined in the SSIS package.

Thanks
0
Comment
Question by:AXISHK
  • 2
  • 2
4 Comments
 
LVL 15

Expert Comment

by:derekkromm
ID: 35103018
open your sql agent job
edit the ssis step
there should be a "set values" tab - thats where you can set variables
property path is: Package.Variables[User::<var name>].Value
value is whatever you want to set it to
0
 

Author Comment

by:AXISHK
ID: 35103335
Sorry, still couldn't sort out how to put the SSIS variables into the corresponding field. Suppose the variables are defined in SSIS as shown below. How to put them into the corresponding fields in SQLAgent.

Great thank again.

SQLAgent.bmp
SSIS.bmp
0
 
LVL 15

Accepted Solution

by:
derekkromm earned 500 total points
ID: 35104308
Property Path: Package.Variables[User::EndDate].Value
Value: "2/9/2011"

Property Path: Package.Variables[User::StartDate].Value
Value: "2/1/2011"

0
 

Author Closing Comment

by:AXISHK
ID: 35221578
Tks.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now