locked
Environment variable(%Variable%) in SSIS Connection manager RRS feed

  • Question

  • 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.
    Friday, May 18, 2012 5:28 AM

Answers

  • Hello,

    Follow the article below. It may help you.

    http://www.mssqltips.com/sqlservertip/1405/sql-server-integration-services-ssis-package-configuration/

    • Proposed as answer by Eileen Zhao Thursday, May 24, 2012 8:11 AM
    • Marked as answer by Eileen Zhao Thursday, May 24, 2012 8:53 AM
    Friday, May 18, 2012 7:29 AM

All replies