Delimited File Reader Source

Rating:        Based on 7 ratings
Reviewed:  6 reviews
Downloads: 10101
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 - 1511 downloads

Other Available Downloads

Application DelimitedFileReaderSetup.msi
application, 586K, uploaded Sep 24, 2008 - 3837 downloads
Documentation DelimitedFileReaderReadme.rtf
documentation, 177K, uploaded Sep 24, 2008 - 4094 downloads
Application DelimitedFileReaderSetup_SQL2012.msi
application, 52K, uploaded Apr 18, 2012 - 659 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 at 8:40 PM
     
Unable to evaluate (2012) because the installer quits without installing. Very disappointed.
by marykdba on Jul 30 at 7: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 at 4: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 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