Iam loading a parent table first then trying to load the FK table but since the SQL Server Connection Manager does a bulk/fast load if 1 FK does not exist in the first table the whole load fails. I want it to load and just write out to my DB errors flat file the FK errors. How do I do this.

Take the error output of the source for child table and connect it to a flat file destination. You also need to set the error rows to be redirected, instead of fail the package. This can be done in the Error Output tab of your OLE DB Source or ADO.NET Source. Please mark as answer if this helps. Thank you. http://thebipalace.wordpress.com

I alreay did that. I fixed it by changing from a fast load to a normal load.