Hi Craig,

Thanks for your reply.I opened the package in BIDS but i was not able to see any errors.

Also compared the columns between the source and target and was not able to find any differences.(Datatype and Length)

What could have caused this error?