Ed77


We are porting an existing package from SQL Server 2005 to Katami and are getting the following error:

Code: 0xC0209303 Source: MasterSSIS Connection manager "SSISOperations" Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider is not registered -- perhaps no 64-bit provider is available. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2007-09-14 09:43:35.00 Code: 0xC0209303 Source: MasterSSIS Connection manager "SSISOperations" Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR. The requested OLE DB provider is not registered -- perhaps no 64-bit provider is available. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Component... The package execution fa...

Katami is installed on Longhorn Server




Re: SSIS package failing

Michael Entin - MSFT


> 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







Re: SSIS package failing

Ed77

It is the Flat-File provider. Importing from a .csv file into a table.

Thanks,

Ed






Re: SSIS package failing

Michael Entin - MSFT

The error seems to indicate that "SSISOperations" connection manager is OLEDB connection manager, but the appropriate provider is not installed. So which provider is it






Re: SSIS package failing

Ed77

The SSISOperations in an OLEDB connection - it connects to a SQL database that drives the rest of the SSIS package execution. Shouldn't the 'standard' providers be installed as part of Katmai

Thanks,

Ed





Re: SSIS package failing

Michael Entin - MSFT

If you used SNAC provider, the SQL 2005 version of this provider is not installed with SQL 2008. You can either install it from SQL 2005 disk, or change the connection manager to use SNAC 2008 (this should happen automatically in future, but this code is not in CTP yet).

You do it individually by clicking on the connection and editing the ConnectionString property, or bulk edit .dtsx files with Find/Replace.

Replace

Provider=sqlncli.1

with

Provider=sqlncli10.1

And your connections will use SNAC for SQL 2008.