Delimited File Reader Source

Rating:        Based on 4 ratings
Reviewed:  3 reviews
Downloads: 7914
Released: Sep 24, 2008
Updated: Apr 18, 2012 by MattCarroll
Dev status: Alpha Help Icon

Recommended Download

Documentation DelimitedFileReaderReadme_SQL2012.rtf
documentation, 184K, uploaded Apr 18, 2012 - 710 downloads

Other Available Downloads

Application DelimitedFileReaderSetup.msi
application, 586K, uploaded Sep 24, 2008 - 3280 downloads
Documentation DelimitedFileReaderReadme.rtf
documentation, 177K, uploaded Sep 24, 2008 - 3699 downloads
Application DelimitedFileReaderSetup_SQL2012.msi
application, 52K, uploaded Apr 18, 2012 - 225 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 the desired functionality that the flat file data source should of had in SSIS. WELL DONE!
by CSIROSwan on May 26, 2009 at 12: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 4:40 PM
     
To refernce the problem that was solved by this component, see my previous post: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/fe6be73a-d0d5-4d41-8d09-db5fe32f0d68 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 5:33 PM