SSIS package failing

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

[1284 byte] By [Ed77] at [2008-2-13]

«« New To Sharepoint & ASP.NET
»» Overriding CallABGreetingProc and ABGreetingProc

# 1

> 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?

MichaelEntin-MSFT at 2007-10-3 >

top of Msdn Tech,SQL Server Katmai,SQL Server Katmai Integration Services...

# 2

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

Thanks,

Ed77 at 2007-10-3 >

# 3

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?

MichaelEntin-MSFT at 2007-10-3 >

# 4

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,

Ed77 at 2007-10-3 >

# 5

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.

MichaelEntin-MSFT at 2007-10-3 >

SQL Server Katmai Hot Topic

SQL Server Katmai New Topic

SQL Server Katmai

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Question about 'SSIS package failing', No.2151577,Posted by Ed77

SSIS package failing

SQL Server Katmai Hot Topic

SQL Server Katmai New Topic

SQL Server Katmai

Site Classified