Wednesday, September 29, 2010

SQL Server 2008 Service Pack 2 released


SQL Server 2008 SP 2 released on 29 Sep 2010.

To download the SQL Server 2008 SP2 release please select from the links below:

Tuesday, September 14, 2010

Oracle Linked Server issue

Today I got the error below on the SQL Server job it runs a SSIS Package.

Msg 7302, Level 16, State 1, Server USIVA007, Line 1
Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server

  Strange but recreating of the Linked Server connection, resolved the issue.

Techniques to Debug Connectivity Issues to an Oracle Server Using the ODBC Driver and OLE DB Provider