SQL Agent / SSIS Package

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » SQL Agent / SSIS Package - Set Values

SQL Agent / SSIS Package - Set Values

Rate Topic

Display Mode

Topic Options

Author

Message

dave-dj

Posted Tuesday, March 12, 2013 11:01 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 20, 2013 11:47 AM
Points: 380, Visits: 1,014

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

Koen Verbeeck

Posted Friday, March 15, 2013 7:37 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:11 AM
Points: 9,378, Visits: 6,473

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

dave-dj

Posted Friday, March 15, 2013 10:22 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 20, 2013 11:47 AM
Points: 380, Visits: 1,014

Thanks Koen.

_____________________________________________________________________________
MCITP: Business Intelligence Developer (2005)

Post #1431621

« Prev Topic | Next Topic »

Permissions