Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error executing SSIS package from BPC Excel


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.



Former Member
Former Member replied

I got the error before and it was caused by data file whose one of its column is blank and converted to a numeric (signeddata).

So check your source data if all is clean, especially the columns which perform conversion from the source to the target in SSIS Data Flow Task.


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question