Given the great detail that's possible, and may be required, would it be possible to create additional libraries of functions that have many defaults set up. For example, the code below (taken from your article) would appear to be used for most text data files:

cnFile.Properties("ColumnNamesInFirstDataRow").SetValue(cnFile, True)

cnFile.Properties("DataRowsToSkip").SetValue(cnFile,0)

cnFile.Properties("RowDelimiter").SetValue(cnFile,vbCrLf)

cnFile.Properties("TextQualifier").SetValue(cnFile,"""")

cnFile.Properties("HeaderRowsToSkip").SetValue(cnFile, 0)

cnFile.Properties("HeaderRowDelimiter").SetValue(cnFile,vbCrLf)

cnFile.Properties("CodePage").SetValue(cnFile,1252)

It is not yet apparent to me the benefit of this technique over DTS for the majority of file transformations.

Let me know if my reasoning on this issue makes sense.

Thanks

AndreQ1