Solved

Pass variables to SSIS package

Posted on 2011-03-10
4
596 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
TOOLS - convert T-SQL TO PL/SQL 3 54
sql help 8 58
Query Syntax 17 43
Negative isnull? 3 14
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Copy Database Wizard 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.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

860 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