Generate the Empty Files with Header only in SSIS

 We have got the requirement that we need to generate the empty file only with the header column.

In this demo we have seen who we can generate the empty file only with the header.

Here we are taking the data flow task

   

And taking the source as the OLEDB source.

  

Here we are using AdventureWorks2012 database and exporting the HumanResources.Department table columns in the flat file.

Now we are writing the sql script to return the header only. See below.

  

His query always returns the header only.

Now we are taking the flat file and creating the connection.

  

After that doing the mapping.  

Click ok.

The package is ready to run.

Running the package.

Package executed successfully.

  

Now see the flat file.

  

File created with Empty records only with the column header.