Bulk Insert and Table Size - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Bulk Insert and Table Size

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-10 : 08:14:41

Richard writes "Hi

I have a rather large amount of data to bulk insert into a table. Approx. 15 Gb in flat file format. What I am finding is that when I do a bulk insert the Table size is in the region of 160 Gb.

The table has no indexes and the table structure is made up of ints, float, smallint and datetime.

The table structure is as follows:

Col1 int
Col2 int
Col3 int
Col4 float
Col5 Datetime
Col6 SmallInt
Col7 int
Col8 int
Col9 int
Col10 int

The bulk insert properties are as follows:

BULK INSERT Table FROM 'Filename'
WITH (
CODEPAGE = 'ACP',
DATAFILETYPE = 'char',
FIELDTERMINATOR = '|',
MAXERRORS = 0,
ROWTERMINATOR = '\n'
)

Any help here would be fantastic as I have been tearing my hair out trying to resolve this one."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources