Linked server in SQL Server 2005 to Sybase ASE 12.5 can be created with both ODBC driver and OLEDB provider. Below are the steps. A. Creating Linked server for Sybase ASE 12.5 from SQL Server using DataDirect Sybase Wire Protocol ODBC driver...

Cause and Resolution SSIS uses the value of Registry key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTS\ServiceConfigFile" to locate the location of SSIS configuration file on the machine. If this key doesn’t exist or doesn’t point to the...

1. After connecting to SQL Server Integration Services 2005 from SQL Server Management Studio, when you expand MSDB under Stored Packages to see list of stored packages, you may get below error. Failed to retrieve data for this request...

This is a very generic error and can occur due to multiple reasons. I am documenting as much as of them based on Case studies. Refer to the description and the error codes for each of the unique errors. A: Error: "DTS_E_OLEDBERROR. An...