Pages

Tuesday, January 19, 2016

Bulk insert task is used to copy large amount of data into SQL Server table or view. Assume your company maintaining the information in mainframe systems and the information having millions of rows and but the company’s online shopping website using SQL server database for populating the data into front end application. You can’t copy huge data into sql server into tables from mainframe system and the list products saved in comma-delimited format for this bulk insert task is very use full to move the data very fast. Main purpose is high speed data copying, where as general transformations can’t do this operation very fast.