I have received a SSIS package and asked to review and test the package. OLEDB connection manager is used to connect to database in that package. When I opened the OLEDB connection manager I found %SERVERNME% in place of SERVER Name and %DBNAME% in place of Database Name. I know %<variable>% denotes environment variable. I created two environment variables (SERVERNME and DBNAME) in System Properties -> Advanced -> Environment Variable. After that whenever I tried to run the SSIS package it raised error "[Execute SQL Task] Error: Failed to acquire connection <connection name>. Connection may not be configured correctly or you may not have the right permissions on this connection.". I can not understand how to solve this problem. Please help.

Hello, Follow the article below. It may help you. http://www.mssqltips.com/sqlservertip/1405/sql-server-integration-services-ssis-package-configuration/