6

I have package which have sequence container and inside that sequence container there is 10 child sequence container each container represents the single table. When I execute that Package to through the SQL Server Job all eight or nine container execute successfully but only one or two container give error which has given below. But when we go to the package and right click on error container and execute them it executes success fully. Please help me to solve this mystery.

"OLE DB Destination" (4403) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (4416). 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. There may be error messages posted before this with more information about the failure. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:30:00 AM Finished: 3:01:13 AM Elapsed: 9072.95 seconds. The package execution failed. The step failed.

Improve this question
2

5 Answers 5

Reset to default
2

My case is that implicit conversion is failing. This occurs when attempting to import different uppercase and lowercase value field. So you could check the fields match values into SSIS and find differences (upper & lower case)

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

In my case I had to add brackets and explicit cast a value to GUID (with Derived Column Transformation): (DT_GUID)("{" + ProductId + "}").
0

This is a connection timeout error.

Solution: Use fast load mode, i.e. Table or view - fast load.

Improve this answer

Comments

0

Check following:

  1. Check if there is proper mapping between source and destination.
  2. Login is working.
  3. Connection is not broken.
  4. Check if the SQL server has short connection timeout.
Improve this answer

Comments

0

Check if the destination is not using a connection manager added for the source.

Improve this answer

Comments

-1

Check the user(login and password) of the connection you use in your OLEDB. If the user you configured in the connection does not have rights on ther server it wont work. Do not forget to check the "save password" option if you'd entered a specific user.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.