Which way is better to port around 60000 data into database automatically per day

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Which way is better to port around 60000 data...

Which way is better to port around 60000 data into database automatically per day

Rate Topic

Display Mode

Topic Options

Author

Message

Chandhini

Posted Tuesday, December 01, 2009 3:42 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 10, 2011 12:15 PM
Points: 35, Visits: 210

Hi,
Which way is better to port around 60000 records from one CSV file into database through schedular per day (every day old data will be removed and new data will be inserted). For time being, m using select * from openrowset query in one sp and create a schedular for that.
but if i need to execute that sp, admin privilege is needed. is there any other way to achieve this?

Post #826544

vidhya sagar

Posted Tuesday, December 01, 2009 5:58 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 2:45 AM
Points: 416, Visits: 521

You can achieve this using bcp or BULK INSERT. You can also try SSIS or DTS

Regards..Vidhya Sagar
SQL-Articles

Post #826582

Chandhini

Posted Wednesday, December 02, 2009 3:06 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 10, 2011 12:15 PM
Points: 35, Visits: 210

Thanks a lot.
let me try these option.

Post #827284

ChiragNS

Posted Wednesday, December 02, 2009 11:21 PM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365, Visits: 1,825

BULK Insert or BCP are specifically for importing lot of data into sql server. If you are using either of them inside a procedure you can create a job that calls the procedure and schedule the job.

SSIS also internally uses the same and it can be scheduled.

"Keep Trying"

Post #827952

« Prev Topic | Next Topic »

Permissions