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