How to Create a Comma Separated Delimited Text File Using SQL Server 2008
9. In “Save and Run Package” wizard screen there are basically two options which are available. One option will be to run the SSIS package immediately once the package is created and the second option is to save SSIS package. There are two ways to save an SSIS package, one option is to save the package in SQL Server and the second option is to save the package as a File system. If you have chosen the option to save the package as SQL Server then the package will be stored in MSDB database of SQL Server. However if you are choosing to save the SSIS package as a File system then the package can be saved as a DTSX file on the disk just like any other file. For this example File system option is selected and the package protection level is chosen as “Do not save sensitive data”. Click Next to continue with the wizard.
10. In “Save SSIS package” wizard screen provide the Name and Description for the SSIS package. Next you need to specify the path where the SSIS Package needs to be stored as file system as shown in the below snippet. Click Next to continue with the wizard.
11. In “Complete the Wizard” screen you can see the summary of all the choices which you have made till now within the wizard. Finally in order to execute the SSIS package click on Finish button.
12. Once the package has executed successfully all the 19185 rows will be exported to SalesCustomer.txt comma separated delimited text file. The package execution details are shown in the below snippet.
You can view the report by clicking the reports button and finally to close the SQL Server Import and Export Wizard you can click on Close button.
SSIS Package Execution Result
Once the package has successfully executed the SalesCustomer.txt comma separated delimited text file is generated as shown in the below snippet. The very first row in SalesCustomer.txt file mentions the column names in Sales.Customer table of AdventureWorks database.”
In this article you have seen how easily you can generate a comma separated delimited text file using the SQL Server Import and Export Wizard. The same steps you need to follow to generate a comma separated delimited text file from SQL Server 2005.