• Also, in general, an OLE DB destination will be faster than an ADO.NET destination. So, I would switch back to OLE DB and do as happycat suggests and make sure you're using fastload.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato