posted on Friday, January 12, 2007 9:07 PM by admin

SSIS Raw File Reader Review

As promised in an earlier post, I've tested the SSIS Raw File Reader released by Simon Sabin this past week.

Here's how I tested it:

First, I start a new SSIS project. I rename the package RawFileGen.dtsx. I add a Data Flow Task to the Control Flow as shown:

I double-click the Data Flow Task to edit it and add an OLE DB Source. I double-click the OLE DB source to edit it and aim it at the AdventureWorks.HumanResources.Employee as shown:

I add a Raw File Destination and configure it to dump the results to a file as shown:

I check the Input Columns to see if all are selected - I want a good test:

I click OK and press the F5 key to execute the package in Debug Mode:

I open the file generated in NotePad - not very legible:

I fire up the SSIS Raw File Reader:

I have to click File|Open and navigate to the file to view the columns:

After that, clicking Tools|Read File loads the data:

And this is a lot easier to read than the Notepad version!

I like it. Good work, Simon!

:{> Andy

Technorati Tags: SSIS Raw File Raw File Reader

Comments