May 21, 2008 at 10:01 am
I am getting the following error in my ssis pkg, when am trying to insert emp details in the destination table. Actually before this sql cmd insert task am doing some lookups also. My lookups are returning rows but when it come to insert task it fails.
SSIS package "GetEmp.dtsx" starting.
Information: 0x4004300A at EmployeeIntegration, DTS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at EmployeeIntegration, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at EmployeeIntegration, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x400490F4 at EmployeeIntegration, LookupTaxCategoryID [1875]: component "LookupTaxCategoryID" (1875) has cached 7 rows.
Information: 0x400490F4 at EmployeeIntegration, LookupPayCategoryID [1926]: component "LookupPayCategoryID" (1926) has cached 5 rows.
Information: 0x4004300C at EmployeeIntegration, DTS.Pipeline: Execute phase is beginning.
Error: 0xC0202009 at EmployeeIntegration, INSERT Employees [1962]: An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E21 Description: "Invalid input parameter values. Check the status values for detail.".
Error: 0xC020901C at EmployeeIntegration, INSERT Employees [1962]: There was an error with input column "Salutation" (5811) on input "OLE DB Command Input" (1967). The column status returned was: "DBSTATUS_UNAVAILABLE".
Error: 0xC0209029 at EmployeeIntegration, INSERT Employees [1962]: The "input "OLE DB Command Input" (1967)" failed because error code 0xC020906E occurred, and the error row disposition on "input "OLE DB Command Input" (1967)" specifies failure on error. An error occurred on the specified object of the specified component.
Error: 0xC0047022 at EmployeeIntegration, DTS.Pipeline: The ProcessInput method on component "INSERT Employees" (1962) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
Error: 0xC0047021 at EmployeeIntegration, DTS.Pipeline: Thread "WorkThread4" has exited with error code 0xC0209029.
Information: 0x40043008 at EmployeeIntegration, DTS.Pipeline: Post Execute phase is beginning.
Information: 0x40043009 at EmployeeIntegration, DTS.Pipeline: Cleanup phase is beginning.
Task failed: EmployeeIntegration
SSIS package "GetEmp.dtsx" finished: Success.
May 21, 2008 at 11:18 am
It looks like you are using an "OLE DB Command" component rather than an "OLE DB Destination" component. Is that correct?
If so, I think you have a data type issue between your data flow and your table.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply