Welcome to EMC Consulting Blogs Sign in | Join | Help

SSIS Junkie

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.



Published Thursday, May 25, 2006 6:15 PM by jamie.thomson



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 4:47 PM

jamie.thomson said:


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


January 4, 2008 7:18 PM
New Comments to this post are disabled

This Blog


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