We have an SQL SERVER 2008 R2,in which it has two SSIS packages deployed on it.(We do not have access to the SSIS code) and We know that these SSIS packages use Config file for the connecting information.If I export those SSIS packages,How should I behave with their config files?
I exported SSIS packages to a new server and manullay copied the config files there and changed the server name in them.When I created a job and execute the SSIS packages in new environment,still they point to the old sever(although I have applied the changes on Config file).
You may want to inspect the package opened in BIDS or VS 2008 for the logging setup. There must be a connection manager for the log.
The issue must be here: the package is looking for a config file in a place specified there, does not find it and therefore applies the design time settings.
Arthur My Blog
Actually I added a output log,but I did not see any warning .Also, there is check box next to connection in connection Manager,when I checked that checkbox,the job fails with following errors:
Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider SQLNCLI11 is not registered -- perhaps no 64-bit provider is available. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
Description: Failed to acquire connection "TestDB". Connection may not be configured correctly or you may not have the right permissions on this connection.
- Edited by Mourmansk Tuesday, June 12, 2012 9:43 PM