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 2005 Forums
 SSIS and Import/Export (2005)
 Need to import huge data from text file (3G)

Author  Topic 

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2009-12-02 : 16:26:51
I need to import huge data from text file (3G) with fixed length into a existing SQL table.
Can someone give me a hint?

smeeluv
Starting Member

20 Posts

Posted - 2009-12-03 : 08:23:46
You may want to try a bulk load option like bulk insert task. I have never used it but it should run data through much faster than a data flow task. Hope this helps!
Go to Top of Page
   

- Advertisement -