Skip to content

Matt Masson

SQL Server Integration Services (SSIS), Power Query (PQ), Azure Data Factory (ADF), and general Data Integration

Generate an Empty Raw File Without Running your SSIS Package

  • Home
  • 2013
  • December
  • Generate an Empty Raw File Without Running your SSIS Package
Quick Tip, SQL Server MattDecember 6, 2013

A new feature was added to the Raw File Destination in SQL Server 2012 which allows you to output an empty raw file from the editor UI.

  1. Add a Raw File Destination to your data flow, and connect it to the previous transform
  2. Double click to open the Raw File Destination Editor
  3. Configure the file name
  4. Click on the Columns tab, and select the columns you want included
  5. Click on the Connection Manager tab
  6. Click the Generate initial raw file … button
  7. A dialog confirming the output columns will pop up. Click OK to create your file.

 

image

 

This functionality is handy when you are using raw files to stage data between data flows. You can use this empty raw file in the Raw File Source to configure the metadata it needs. In previous versions, you would have had to run the package to produce the initial file.

Another note – Raw Files were improved in SQL Server 2012 to include sort information, so now the IsSorted flag is automatically set in the Raw File Source.

 

image

Data FlowSSIS

Post navigation

Using Hive ODBC from SSIS
Creating a Date Dimension with a Power Query Script

Copyright © 2021 | All Rights Reserved. CorpoNotch by Shark Themes