blogs.conchango.com

welcome to the conchango blogging site
Welcome to blogs.conchango.com Sign in | Join | Help
in Search

SSIS Junkie

Conchango are busy and need talented consultants in and around London. Interested? Email me or send me a message

SSIS: Warning but no error if an environment variable is missing

I have spoken previously about indirect configurations and tried to convince everyone of how useful they are.

I noticed something today concerning indirect configurations that quite surprised me. If you execute a package that uses an indirect configuration and the environment variable is not present you get the following warning:

The configuration environment variable was not found.  The environment variable was: "Seer.ConnectionManager.CUECommonReference". This occurs when a package specifies an environment variable for a configuration setting but it cannot be found. Check the configurations collection in the package and verify that the specified environment variable is available and valid. 

I was surprised because I would have expected the package to throw an error rather than a warning. I questioned this and Matt David from the SSIS team replied here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=425031&SiteID=1

You kinda get the feeling that it might have been decided with the toss of a coin :)

 

Regardless of that, its just something to be aware of. If you forget to deploy your environment variable then you will not get an error.

That is all.

-Jamie

 

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Laura Beranek said:

I am getting this same warning when I add a new environment variable.  What do I have to do to get it recoginize the environment variable.  I have stopped/started SQL Agent.  Do I have to stop/start SQL Server as well?

January 4, 2008 16:47
 

jamie.thomson said:

Laura,

You shouldn't have to, no. Can't think what's wrong. Try rebooting.

-Jamie

January 4, 2008 19:18

Leave a Comment

(required) 
(optional)
(required) 
Submit

This Blog

Syndication

News

Powered by Community Server (Personal Edition), by Telligent Systems