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