SQLServerCentral / SQL Server 2005 / SQL Server 2005 General Discussion / Which way is better to port around 60000 data into database automatically per day / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 19:18:30 GMT20RE: Which way is better to port around 60000 data into database automatically per dayhttp://www.sqlservercentral.com/Forums/Topic826544-149-1.aspxBULK 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.Wed, 02 Dec 2009 23:21:34 GMTChiragNSRE: Which way is better to port around 60000 data into database automatically per dayhttp://www.sqlservercentral.com/Forums/Topic826544-149-1.aspxThanks a lot.let me try these option.Wed, 02 Dec 2009 03:06:05 GMTChandhiniRE: Which way is better to port around 60000 data into database automatically per dayhttp://www.sqlservercentral.com/Forums/Topic826544-149-1.aspxYou can achieve this using bcp or BULK INSERT. You can also try SSIS or DTSTue, 01 Dec 2009 05:58:41 GMTvidhya sagarWhich way is better to port around 60000 data into database automatically per dayhttp://www.sqlservercentral.com/Forums/Topic826544-149-1.aspxHi,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?Tue, 01 Dec 2009 03:42:33 GMTChandhini