SSIS Package failed

Question

I am running Windows Server 2003 R2 Enterprise Edition SP 2

I have created an integration package in VS 2005 which extracts data from Excel and imports it into a table on SQL server 2005 running on this server.

The package runs ok in Visual Studio 2005,I did a bit of research which suggests this is due to SQL 64 bit and Windows 64b bit, however I am running 32 bit !!

Description: An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" H result: 0x80040154 Description: "Class not registered". End Error Error: 2010-01-04 16:02:19.14 Code: 0xC00291EC Source: Delete from ExcelDB Execute SQL Task Description: Failed to acquire connection "Co nnection may not be configured correctly or you may not have the right permissio ns on this con

Please help to resolve this issue

Answer 1

A couple of suggestions of things you could try

It says that its failing on 'Microsoft OLE DB Service Components'. Can you identify this component, and include it in a simple C#/VB.NET project. Perform a simple test within the project code, e.g. instantiate it and call a method. Then compile this to an EXE, transfer across to your server, and run it there.

The next thing to try is to trace the fault using Process Monitor: http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx

This is not for the faint hearted, as you could get tens of thousands of entries, but its possible to narrow the entries down: 1) Turn trace off and clear all your entries before you start. 2) Start the trace then quickly, start your package (e.g. have a command line keyed up) 3) Stop the trace as quickly as possible once you get the errors.

With any luck you might be able to determine where exactly the failure is occurring. This tool has been invaluable in the last few months, and I've followed similar step on a number of occasions.

Good luck