{"id":8643,"date":"2020-01-16T22:54:16","date_gmt":"2020-01-16T22:54:16","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=8643"},"modified":"2025-09-25T22:01:56","modified_gmt":"2025-09-25T22:01:56","slug":"convert-sql-to-csv-ssis","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/","title":{"rendered":"How to convert SQL to CSV in SSIS"},"content":{"rendered":"

How to convert SQL to CSV in SSIS<\/h2>\n

There are several tricks related to converting SQL to CSV. For example, dates, working with variables, converting text, working with stored procedures. In this article, we will work with several tips to convert SQL Server data to the CSV format.<\/p>\n

Prerequisites<\/span><\/h2>\r\nBefore we perform the steps listed in this article, you will need to make sure the following prerequisites are met:\r\n
    \r\n \t
  1. SSIS<\/abbr> designer installed.\u00a0Sometimes it is referred to as BIDS<\/abbr> or SSDT<\/abbr> (download it from the Microsoft site<\/a>).<\/li>\r\n \t
  2. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\r\n \t
  3. Make sure\u00a0ZappySys SSIS PowerPack<\/a><\/span>\u00a0is installed (download it<\/a>, if you haven't already).<\/li>\r\n \t
  4. (Optional step<\/em>).<\/em>\u00a0Read this article<\/a>, if you are planning to deploy packages to a server and schedule their execution later.<\/li>\r\n<\/ol><\/div>

    Prerequisites<\/span><\/h2>\r\nBefore we perform the steps listed in this article, you will need to make sure the following prerequisites are met:\r\n
      \r\n \t
    1. SSIS<\/abbr> designer installed.\u00a0Sometimes it is referred to as BIDS<\/abbr> or SSDT<\/abbr> (download it from the Microsoft site<\/a>).<\/li>\r\n \t
    2. Basic knowledge of SSIS package\u00a0development using\u00a0Microsoft SQL Server Integration Services<\/em>.<\/li>\r\n \t
    3. Make sure\u00a0ZappySys SSIS PowerPack<\/a><\/span>\u00a0is installed (download it<\/a>, if you haven't already).<\/li>\r\n \t
    4. (Optional step<\/em>).<\/em>\u00a0Read this article<\/a>, if you are planning to deploy packages to a server and schedule their execution later.<\/li>\r\n<\/ol><\/div>\n

      For this article, we will use the following ZappySys component:<\/p>\n

      \n\n\n\n

      \n\"SSIS<\/a><\/td>\n      		SSIS Export CSV File Task
      \n<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

       <\/p>\n

      How to convert SQL to CSV using specific dates<\/h2>\n
        \n
      1. First, to convert the date to a specific format, you can use the Export CSV task.<\/li>\n
      2. This task allows you to convert SQL Server tables into CSV files. We will show how to set the date to a specific format:\n
      3. The query used for this purpose is the following:\n
        SELECT [OrderID] ,FORMAT([OrderDate], 'dd\/MM\/yyyy') as mydateformat FROM [dbo].[Orders]<\/pre>\n<\/li>\n
      4. As you can see, you can send custom queries in the Export CSV task.
        \nIn this example, we utilize the T-SQL Format function, which enables us to convert the date to a custom format. In this example, we are converting the OrderDate column into the format dd\/MM\/yyyy.<\/li>\n
      5. Also, specify the destination path:\n
      6. Finally, run the package. In this example, we converted the date to the format dd\/MM\/yyyy.<\/li>\n<\/ol>\n
        How to convert SQL Server to CSV using dynamic column names<\/h2>\n
          \n
        1. A common question is to have column names based on SSIS variables. This time, we will show how to do this.<\/li>\n
        2. First of all, we will need an SSIS variable that will contain the column\u00a0name:\n
        3. Secondly, we need to use the value of the variable as the column name.\u00a0We will use the alias (AS in SQL) to create a custom name.\n
          <\/div>\n
        4. The SQL query will look like this:\n
          SELECT [ShipperID] as {{User::column}} FROM [Northwind].[dbo].[Shippers]<\/pre>\n<\/li>\n
        5. The previous example used the SSIS variable named column to store the name of the column. If the Variable value is ‘column1’, the name of the column will be ‘column1’.<\/li>\n<\/ol>\n
          How to convert SQL Server to CSV to change the decimal point to a decimal\u00a0comma<\/h2>\n
            \n
          1. Most of the countries in the world use the decimal point or the decimal comma. For decimals, some countries use the comma and others the period. In this new example, we will show how to convert decimal data into a comma.<\/li>\n
          2. In order to convert, we will convert and work with a text data type. We\u00a0will use the following script to create a table with data:\n
            create table decimalpoint\r\n(\r\ndecimal nvarchar(50)\r\n)\r\n\r\ninsert into decimalpoint values \r\n('3,45'),\r\n('3,44'),\r\n('6,56')<\/pre>\n<\/li>\n
          3. Secondly, we will use the following T-SQL Sentence: select replace(decimal,’,’,’.’) as mydecimal from decimalpoint.\n
            select replace(decimal,',','.') from decimalpoint<\/pre>\n<\/li>\n
          4. In addition, we will create a path to export.<\/li>\n
          5. If everything is fine, the CSV file created will convert the period decimal\u00a0to a coma decimal.<\/li>\n<\/ol>\n
            How to export data from a parameterized SQL Server stored procedure into a
            \nCSV file<\/h2>\n
              \n
            1. In this new example, we will use a stored procedure with parameters and\u00a0store the results into a CSV file.<\/li>\n
            2. \u00a0First of all, we will use the following parameterized stored\u00a0procedure:\n
              create procedure [dbo].[Sales by Year]\r\n@Beginning_Date DateTime, @Ending_Date DateTime AS\r\nSELECT Orders.ShippedDate, Orders.OrderID, \"Order Subtotals\".Subtotal, \r\nDATENAME(yy,ShippedDate) AS Year\r\nFROM Orders INNER JOIN \"Order Subtotals\" \r\nON Orders.OrderID = \"Order Subtotals\".OrderID\r\nWHERE Orders.ShippedDate Between @Beginning_Date And @Ending_Date\r\nGO<\/pre>\n<\/li>\n
            3. Secondly, we will invoke the stored procedure like this:\n
              <\/div>\n
            4. Finally, if everything is fine, the data will be exported to the CSV\u00a0file after running the package.<\/li>\n<\/ol>\n
              Conclusion<\/h2>\n
              In this article, we demonstrate how to export data to CSV from SQL Server using various date formats. We also learned how to change the types of decimals used. For more fun, please\u00a0download our components.<\/a><\/p>\n
               <\/p>\n
               <\/p>\n","protected":false},"excerpt":{"rendered":"
              How to convert SQL to CSV in SSIS There are several tricks related to converting SQL to CSV. For example, dates, working with variables, converting text, working with stored procedures. In this article, we will work with several tips to convert SQL Server data to the CSV format. For this article, we will use the […]<\/p>\n","protected":false},"author":5,"featured_media":3074,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[127],"tags":[128,284,283,12],"yoast_head":"\r\nHow to convert SQL to CSV in SSIS | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"How to convert SQL to CSV in SSIS - ZappySys Blog\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to convert SQL to CSV in SSIS | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"How to convert SQL to CSV in SSIS - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2020-01-16T22:54:16+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-09-25T22:01:56+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/SSIS-Json-Source-Adapter.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"100\" \/>\r\n\t<meta property=\"og:image:height\" content=\"100\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys Team\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/\",\"url\":\"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/\",\"name\":\"How to convert SQL to CSV in SSIS | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/SSIS-Json-Source-Adapter.png\",\"datePublished\":\"2020-01-16T22:54:16+00:00\",\"dateModified\":\"2025-09-25T22:01:56+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\"},\"description\":\"How to convert SQL to CSV in SSIS - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/SSIS-Json-Source-Adapter.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/SSIS-Json-Source-Adapter.png\",\"width\":100,\"height\":100},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to convert SQL to CSV in SSIS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e\",\"name\":\"ZappySys Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g\",\"caption\":\"ZappySys Team\"},\"sameAs\":[\"https:\/\/zappysys.com\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to convert SQL to CSV in SSIS | ZappySys Blog","description":"How to convert SQL to CSV in SSIS - ZappySys Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/","og_locale":"en_US","og_type":"article","og_title":"How to convert SQL to CSV in SSIS | ZappySys Blog","og_description":"How to convert SQL to CSV in SSIS - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/","og_site_name":"ZappySys Blog","article_published_time":"2020-01-16T22:54:16+00:00","article_modified_time":"2025-09-25T22:01:56+00:00","og_image":[{"width":100,"height":100,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/SSIS-Json-Source-Adapter.png","type":"image\/png"}],"author":"ZappySys Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/","url":"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/","name":"How to convert SQL to CSV in SSIS | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/SSIS-Json-Source-Adapter.png","datePublished":"2020-01-16T22:54:16+00:00","dateModified":"2025-09-25T22:01:56+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e"},"description":"How to convert SQL to CSV in SSIS - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/SSIS-Json-Source-Adapter.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/SSIS-Json-Source-Adapter.png","width":100,"height":100},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/convert-sql-to-csv-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to convert SQL to CSV in SSIS"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/91b041e2dcf7ece5f068893c1a68ac6e","name":"ZappySys Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/746bec9c9d27f1b90bb181aa516ee234?s=96&d=mm&r=g","caption":"ZappySys Team"},"sameAs":["https:\/\/zappysys.com"],"url":"https:\/\/zappysys.com\/blog\/author\/dcalbimonte\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/8643"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=8643"}],"version-history":[{"count":12,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/8643\/revisions"}],"predecessor-version":[{"id":11508,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/8643\/revisions\/11508"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/3074"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=8643"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=8643"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=8643"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}