Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 608
  • Last Modified:

Pass variables to SSIS package

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
AXISHK
Asked:
AXISHK
  • 2
  • 2
1 Solution
 
derekkrommCommented:
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
 
AXISHKAuthor Commented:
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
 
derekkrommCommented:
Property Path: Package.Variables[User::EndDate].Value
Value: "2/9/2011"

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

0
 
AXISHKAuthor Commented:
Tks.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now