the instructions for a database to execute a job?

I dont have a lot of experience in database design and SQL Server and how it works behind the scenes. I am...

i'm not sure what you mean there Cozy.

Currently the load process is inside a dataflow task.

Thanks for the reply Cozy.

I was hopeing to totaly abort the import if there was a problem rather then just redirect the error rows. So if there is a problem...