http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660I found a CSV implementation of DataReader on CodeProject (not sure about it's support for datatypes, but it works for strings and is buffered), and I have written a file reader for fixed width fields with DbType support. Since you have transforms working, that may not even be an issue. I am using the IDataReader implementations with SqlBulkCopy to load a table from a batch file across our intranet. After I've finished testing, I could share it with you, but you will probably write something better! I want to be able to construct a FixedFile reader from a format string, but I'm currently supplying a column information array. http://ayende.com/2675/rhino-etl-status-report-joins-distinct-engine-work#comment2http://ayende.com/2675/rhino-etl-status-report-joins-distinct-engine-work#comment2Sat, 04 Aug 2007 01:45:04 GMTRegarding Transactions and Single threading; are you using System.Transactions? If so, would DependentTransaction help here? http://www.pluralsight.com/blogs/jimjohn/archive/2005/05/01/7923.aspx http://ayende.com/2675/rhino-etl-status-report-joins-distinct-engine-work#comment1http://ayende.com/2675/rhino-etl-status-report-joins-distinct-engine-work#comment1Fri, 03 Aug 2007 23:18:23 GMT