Delimited File Reader Source

Rating:        Based on 7 ratings
Reviewed:  6 reviews
Downloads: 13053
Released: Sep 24, 2008
Updated: Apr 19, 2012 by MattCarroll
Dev status: Alpha Help Icon

Recommended Download

Documentation DelimitedFileReaderReadme_SQL2012.rtf
documentation, 184K, uploaded Apr 19, 2012 - 2676 downloads

Other Available Downloads

Application DelimitedFileReaderSetup.msi
application, 586K, uploaded Sep 24, 2008 - 4559 downloads
Documentation DelimitedFileReaderReadme.rtf
documentation, 177K, uploaded Sep 24, 2008 - 4507 downloads
Application DelimitedFileReaderSetup_SQL2012.msi
application, 52K, uploaded Apr 19, 2012 - 1311 downloads

Release Notes

Delimited File Reader Source Sample

This sample includes the binaries for a source component capable of parsing delimited flat files, including files with rows that are missing column fields. Use this sample to learn more about how to:
  • Create custom data flow source components for use with SSIS
  • Use Visual Studio Test Edition-based unit tests to perfom automated unit testing on data flow components
  • Respond to and perform custom UI interaction when a component is dragged to the design surface
  • Redirect error rows to an error output
Written by Bob Bojanic

Reviews for this release

This has worked for me with 2008 server. I can't get the 2012 installer to run successfully. It just quits without finishing.
by ats_white on Jan 15, 2014 at 9:40 PM
Unable to evaluate (2012) because the installer quits without installing. Very disappointed.
by marykdba on Jul 30, 2014 at 8:29 PM
Does not seem to work with SSIS 2012. When trying to Show Advanced Editor get error: Value of 'null' is not valid for 'stream'
by pbboy6gmailcom on May 19, 2014 at 5:56 PM
This has the desired functionality that the flat file data source should of had in SSIS. WELL DONE!
by CSIROSwan on May 26, 2009 at 1:29 PM
The components worked pretty well until I installed SP1 on SQL Server 2008. Now I've got an error: System.Runtime.InteropServices.COMException (0xC0048004): Exception from HRESULT: 0xC0048004 at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSOutputColumnCollection100.get_Item(Object Index) at Microsoft.Samples.SqlServer.SSIS.DelimitedFileReader.BufferSink.AddColumns(RowData rowData).
by irexus on May 20, 2009 at 5:40 PM
To refernce the problem that was solved by this component, see my previous post: Many thanks to Bob Bojanic who designed this Dataflow component and placed it on this site. It solved a problem with PrimeOutput failing a task instead of redirecting CSV problem rows to an error log.
by jkotuby on Mar 30, 2009 at 6:33 PM