SQL filtering OLE DB to OLE DB 247mil rows

[03Explorer]

I am new to SSIS and am trying to pull data from large repository db to SQL 2008 R2. The data is 247,000,000 records with 5 columns of no more than 36 characters. What would be an expected size of the destination table?

I seem to be running out of space... =\ And I am using a fresh DB instance on the destination server (this is the only table).

Am I missing something like a conversion before dropping it into the new db? I am having a hard time believing this data... text data... is taking up this much space (Meaning it is > 10gb).

 

[mrdenny]

The data should be about 8 Gigs give or take. The data types in use will change that a bit. That means that you'll need at least 8 Gigs of transaction log space as well. Also if you've got indexes on the destination table those take up space as well and need to be accounted for.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Site