Categories
MsSQL

SSIS Package: How to export data to CSV file

Create New Business Intelligence Project

Open SQL Server Data Tools and create a new Business Intelligence Project. Navigate to File > New > Project and select Integration Services Project from Template > Business Intelligence > Integration Service. Name the project ExportCSV and choose the location where to save it.

Categories
MsSQL

SQL Server Export Wizard: Export large amount of data to CSV

Sometimes while working with databases, it is necessary to import or export large amounts of data.

Those operations are called Bulk Import/Export operations and are an efficient way to copy data between a SQL Server and a data file.

Export large amount of data to CSV

This article explains how to export large amounts of data from one table to a CSV file using MsSQL Server Export Wizard.