Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Agent / SSIS Package - Set Values Expand / Collapse
Author
Message
Posted Tuesday, March 12, 2013 11:01 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 5:38 AM
Points: 405, Visits: 1,136
Hi all,

I'm trying to run a package from SQL agent and set variables using the using the Set Values tab and then specify the package path and value.

I've check the path and values are correct and no errors are generate.

However, when run the package write files to the default defined location - so it's ignoring the set values?? Is this because itself calls package configuration values??

I guess in short my question in what order of precidence does SQL agent / SSIS pick up and configure variables?



_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #1429980
Posted Friday, March 15, 2013 7:37 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:49 AM
Points: 13,306, Visits: 10,171
Read the part Understanding How Package Configurations Are Applied at Run Time

Package Configurations




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1431532
Posted Friday, March 15, 2013 10:22 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 5:38 AM
Points: 405, Visits: 1,136
Thanks Koen.

_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)
Post #1431621
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse