SSIS -How to Convert Excel File To CSV ( Comma Separated values) File in SSIS Package


Our business users create excel file. We need to send this file to vendor but vendor only accepts csv ( Comma separated values) file. We need to convert excel file into csv file by using SSIS Package. 


In this post we will be using Script Task to convert our Excel file into Comma separated values file. The SSIS Package can be modified by using For- each loop container in case where you want to read multiple excel files and convert all of them to csv files. 

Step 1: 

Create an excel file if you don't have one. I have created one for this post as shown below

Fig 1: Sample Excel for to convert to csv by SSIS Package

Step 2: 

Create two variables, one that is pointing to Source Excel file and one for destination csv file as shown below.
Fig 2: Create Source and Destination variables for Excel to Csv conversion SSIS Package

Step 3: 

Bring the Script Task to the Control Flow Pane and then choose the above variables in ReadOnlyVariables list.
Fig 3: Map Source and Destination Path variables in Script Task

Click on Edit Script and paste the below script.

#region Namespaces
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using System.Windows.Forms;
using System.Data.OleDb;
using System.IO;

namespace ST_a916a8b3a6d640be9f6302fae0a06c8e
    /// ScriptMain is the entry point class of the script.  Do not change the name, attributes,
    /// or parent of this class.
[Microsoft.SqlServer.Dts.Tasks.ScriptTask.SSISScriptTaskEntryPointAttribute] public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase {
  public void Main() {
  // TODO: Add your code here
//File DataTable from Execel Source File. I have used Sheet1 in my case, if your sheet name is different then change it.
string ConnString; 
 ConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Dts.Variables["User::Var_ExcelFilePath"].Value.ToString() +
                ";Extended Properties=\"Excel 12.0;HDR=No;IMEX=1\";";
            var conn = new OleDbConnection(ConnString);
            string query = "SELECT * FROM [Sheet1$]";
            var command = new OleDbCommand(query, conn);
            OleDbDataAdapter adap = new OleDbDataAdapter(command);
            var datatable = new DataTable();

            //Create csv File

 using (var sw = new StreamWriter(Dts.Variables["User::Var_CsvFilePath"].Value.ToString()))
                for (int row = 0; row < datatable.Rows.Count; row++)
                    var strRow = "";

                    for (int col = 0; col < datatable.Columns.Count; col++)
         strRow += "\"" + datatable.Rows[row][col].ToString() + "\",";
                    //remove last , from row
                    strRow = strRow.Remove(strRow.Length - 1);
                    //write row to file
            Dts.TaskResult = (int)ScriptResults.Success;

        #region ScriptResults declaration

        enum ScriptResults
            Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success,
            Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure


The code I added is in bold, You can copy this code to your script task and leave rest of your code as it is.

Let's run the Package and check if the file is created successfully.

Fig 4: Converted csv File from Excel by using SSIS Package


  1. Hey! I'd like to share this useful online file converter that just work awesome. Make sure to check out.

  2. Thanks You Very Much for your kind to sharing information ......Very Helpful
    pdf flatten online

  3. If you have a different delimiter, apply the changes at this part

    strRow += "\"" + datatable.Rows[row][col].ToString() + "\"~";

  4. If you are just copying the BOLD Code, dont forget to add the namespaces in BOLD
    using System.Data.OleDb;
    using System.IO;

  5. Most likely the simplest technique to convert your slides to digital photos your self is to purchase an off-the-shelf slide to digital image converter. Sure, these do exist they usually do not price as a lot as you may assume. If you want to learn more about this topic, then please visit

  6. Finished edition star x is significantly more expert than iMovie, which has XML fare and the sky is the limit from there.

  7. Very interesting post, Thanks for sharing such useful information here, I must visit your site for more in the future.
    What Is Digital Marketing | Digital Marketing Career Opportunities | Career in Digital Marketing | Digital Marketer Skills

  8. MP4 is a portable Media Player which includes FM transmitters for the transmission of information. flv to mp4

  9. i am browsing this website dailly , and get nice facts from here all the time .

  10. A career in data science is one of the most sought after job these days and for getting ahead in the competition it is important to have relevant skills and knowledge. 360DigiTMG data science training in hyderabad

  11. Thanks for the Information.Interesting stuff to read.Great Article.
    I enjoyed reading your post, very nice share.
    Data Science Course Training in Hyderabad