check the datatypes of the Parameters...you have to make sure that the datatypes should be compatible

Koen Verbeeck process is very good and I hope this is the one of the best and simple way to achieve your requirement

Check your destination table column datatype.I think you are inserting the text values into destination column which is having the datatype as Numeric. 😉

If the destination column is Numeric you...

Have you configured ?

Have you tested your package in development environment?

-If it is working fine in dev enviroment you have to check your permissions in Prod envi.

-Check the properties of...

Hi,

Finally I found the solution.

Its the problem with job configuration.They have configured the job to run at step 2(start step).

Thats why it didn't run the Step1.

Hi

Thanks for your reply.

FailParent and Failpackage both are set to False.

There is one stored procedure in second step.it is running and updating records successfully.

The only problem with the package.

I...