SSIS environment issue

  • I keep getting this error:

    the parameter is configured to use an environment variable but no environment has been selected

    This is not true as the environment has been created and selected and the appropriate environment variable appears on the Configuration tab when setting up the properties of a step for a job.

    This package and it's corresponding environment works and runs just fine on another server, a separate instance of Integration Services.

    The package uses six project connection strings and all have been parameterized. It was complaining about environment variable #6 so I tried hard-coding the connection string in the package configuration instead of using that environment variable. I get the same error but this time on environment variable #5. When I hard code #5, I get the error on #4 etc.

    I've tried deleting the environment, re-creating it with a different name, repointing the project to use the new environment and selecting that environment in the job step and get the same error. I've restarted integration services and SQL Server.

    I'm out of ideas. Anyone?

    "Beliefs" get in the way of learning.

  • Hi,

    Could you please explain the issue bit more on the package deployment. Which server is it deployed? is the same server where environment variable are available? I suggest to check the variables from Computer properties. Check if the variable is case sensitive, check for any blank space issues.

    Regards,

    Vijay

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply