This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Steps to follow when creating a new flat file in SSIS
Using an existing flat file in SSIS is straightforward, but creating a new one can be a pain - this blogs gives some steps to follow.

Posted by Andy Brown on 04 December 2014

In this blog

The Problem
One Solution

Creating New Flat Files in Integration Services

SSIS works pretty well, on the whole, but it always throws me when it comes to creating flat files (writiing to existing flat files is fine, because the column headers are already set up). So here's a quick run through to provide help for anyone who needs it!

The Problem

We want to export a list of X Factor mentors to a flat file:

If you want, you can get a copy of this file here. Here's what the answer will look like:

The text file produced by the package.

One Solution

This isn't the only solution, but it is one which will work. First create a package containing a data flow task as follows:

The data flow task should contain an Excel source.

Now add a Flat File destination from the Other Destinations category (using the Destination Assistant doesn't seem to work):

Double-click on this destination to add it to your data flow task.

Now connect the source to the destination:

Feed the output from the Excel workbook into this new flat file.

Double-click on this destination to configure it - it doesn't yet have a connection:

There is no flat file connection yet, not surprisingly.

Click on the New... button on the right to add a connection:

Click on this button to create a new flat file connection.

Choose the sort of flat file you want to create:

We're going to go for a simple comma-delimited flat file.

Give your connection a name (here we've called ours Link to test file) and also - more importantly - choose what you're going to call the new flat file you're creating (here we're calling it testfile.text):