Thank you so much for everyone's suggestions.

Seems like Bulk Import would work. I tired it, but it says I don't have permission to do a bulk import. The DBA here can't figure out how to give me access (it kinda sucks).

I'm little new to SSIS, so i've never looked redirecting rows. I will go through a tutorial today on redirecting rows. Thanks for your guidance. I think after going through the tutorial, I should be okay.

Ravi.:)