CptCrusty1 (4/23/2013)
Yes, I'm kind of a noob with SSIS. We frequently move hundreds of thousands of records from Text files to Raw tables, and ultimatley to production. After I get the Raw data into a Database table, I use a Data Flow Task to push it to a Staging table.What does Bulk Insert get me? Just throwing it out there to see what comes back.
Bulk Insert allows you to quickly insert rows into a SQL table from an external source, without resorting to SSIS. I can't see how it would fit well into what you are doing at the moment.
Your data flow sounds odd, by the way.
Text File --> Raw File --> database table --> Staging table
Why would you do this? What happens to data in the staging table?
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.