Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Which way is better to port around 60000 data into database automatically per day Expand / Collapse
Author
Message
Posted Tuesday, December 01, 2009 3:42 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Tuesday, December 01, 2009 5:58 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 4:38 AM
Points: 416, Visits: 541
You can achieve this using bcp or BULK INSERT. You can also try SSIS or DTS

Regards..Vidhya Sagar
SQL-Articles
Post #826582
Posted Wednesday, December 02, 2009 3:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Wednesday, December 02, 2009 11:21 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 1:27 AM
Points: 2,366, Visits: 1,837
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 »

Add to briefcase

Permissions Expand / Collapse