Posted on

installing sqlserver 2008: Performance counter registry hive consistency check failed

if, during installation of Sql Server 2008 you have this error : Performance counter registry hive consistency check failed

Open a command prompt with administrator user rights (Run as Administrator)

cd c;/windows/system32
lodctr /R:PerfStringBackup.INI

Restart the system and try again to install sqlserver

Posted on Leave a comment

Sql Server 2014, Integration Services and Oracle

SSIS and SSDT on SQL SERVER 2014

SSIS is not present on Sql Server 2014. To create Integration Service packages, you must download and install SQL Server Data Tools (SSDT).

Download SSDT

You will also use this tool to convert SSIS packages created with Sql Server 2008 into the new project format.

Connect to Oracle from SSDT on SQL SERVER 2014

To connect to Oracle through ADO.NET in the SSDT environment, you must install an Oracle client. You’re definitely working on a 64-bit machine. You must download the 32-bit client and install it by choosing the “Administrative” installation type.