Solved

Pass variables to SSIS package

Posted on 2011-03-10
4
600 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

729 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