DTS-Integration Services

Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider SQLNCLI.1 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”. End Error

The requested OLE DB provider is not registered — perhaps no 64-bit provider is available. And what OLEDB provider you are using? Does it exist for 64-bit, is it installed? The error means that the OLDEDB provider you are using to connect to SQL server is only support on 32 bit run-times To resolve the issue […]

Can’t Expand MSDB in Integration Services Server

A recently built server with names instances fails to expand MSDB folder in Integration services. The Error which pops is very generic which can be seen in below image To get this working you need to update the MsDtsSrvr.ini file with correct sql instance name <ServerName> ServerName\SqlInstanceName</ServerName>   MsDtsSrvr.ini file can be found at installation […]