September 7, 2011 at 1:29 am
We have an text file contents with more than 500 MB , we need to import this file contents to sqlserver 2005 from User Interface. Kindly help us to provide some guidance to accomplished this activity.
With Regards,
Ram.
September 7, 2011 at 1:33 am
You could use bulk insert or SSIS. If it's a one off operation, you could use the import/export wizard.
Have you tried any of these?
-- Gianluca Sartori
September 7, 2011 at 1:37 am
Thanks Gianluca Sartori..!
We have tried with Bulk Insert opertions from UI,but the system performance becomes slow. Sometimes , server session is timed out so we couldn't able to import the contents in to Database. Do you have any other methods to overcome with this problem...!
Regards,
Ram
September 7, 2011 at 1:47 am
You could try to use a lower batch size. This will use less log space (in simple recovery).
The parameter name is BATCHSIZE. See BULK INSERT in BOL for more details.
Another option is using SSIS, either manually or with the wizard.
-- Gianluca Sartori
September 7, 2011 at 2:44 am
SSIS will provide the process for the import.
Should you wish to call this from a user interface, SSIS package can be deployed to a server and user application can call it to run.
---------------------------------------------
If data can screw you, it will; never assume the data are correct.
September 8, 2011 at 1:43 am
Ram
I have no problems to import textfiles with Gbyte size using bulk insert.
You have to give us more details about your set up.
/Gosta
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply