Environment Variable

Configuration settings is always an awkward subject that is because different developers have different preferences on how to do this. EIQ2 manages these connections via an environment variable. The environment variable points to an EIQ2 database “SSISConfig”, where flat file and database connection strings are held.

Note: Throughout this document, the following default server reference: “KB-SQL-01”, needs to change to reflect the correct name for the destination EIQ2 SQL server environment.

• For the correct server name of the EIQ2 server environment, open SQL Server Management Studio and execute the following TSQL statement:

SELECT Convert(Varchar(200), ISNULL(SERVERPROPERTY(‘SERVERNAME’), HOST_NAME()))

• Generate a windows environment system variable against the EIQ2 server called: “SSIS_CONFIG_DB” and with the following variable value:
  • If EIQ2 SQL server is using SQL 2008 R2, replace reference to “SQLNCLI11” with “SQLNCLI10.1”

Data Source=KB-SQL-01;Initial Catalog=SSISCONFIG;Provider=SQLNCLI11;Integrated Security=SSPI;Auto Translate=False

Note: For the above windows environment variable to become active, a server reboot is required