Resender (4/14/2014)
There no error message except for the validation error,cause that stops the execution of the rest of the package
I mean are you redirecting error rows - have you checked the error output?
Like this, I mean.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.