Skip to Content
0
Former Member
Jun 05, 2011 at 07:59 PM

Error executing SSIS package from BPC Excel

301 Views

Hi,

I have a SSIS package that rund fine from MS Visual Studio. If I select the package from BPC Excel I receive the following error:

An error occurred while executing a package
Package Error Events:
ErrorCode = -1071636471
Source = Data Flow Task
SubComponent= OLE DB Source [1]
Description = SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80040E21  Description: "Invalid character value for cast specification".

IDOfInterfaceWithError= {C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}

Package Error Events:
ErrorCode = -1073450982
Source = Data Flow Task
SubComponent= SSIS.Pipeline
Description = component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC0202009.

IDOfInterfaceWithError= {C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}

It worked a couple of days ago, but I cannot figure out what's causing the problem.

Thanks,

Lars