Importing Tables

Algo Rhythm16y ago

My larger tables have between 2 mil and 6 mil rows. These tables can be exported easily to CSV flat files using the Import/Export Wizard, but I can't import them, SSMS stops responding when I try. What is a good way to import data from these flat files? Or What is an easy way to accomplish this? I am forbidden from backing up the entire database, I can only import/export the tables.

Lalit M16y ago

try this

http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/

Bryian Tan16y ago

hi,

I'm not sure how big is your table but mine is just like 4 millions. I use SQL Server Integration Service (SSIS).

Thanks,
Bryian Tan