Quote:> Does anyone have an example of using the flat file OLE DB provider
> (dtsffile.dll) to build a DTSDataPumpTask object.? I would like to
> a DTS package implemeted as an ActiveX exe and I can't find any
> documentation on programming the transformation of text file data using VB
> or VB script.
Does anyone have an example of building a DTSPumpTask using the dtsffile.dll
OLE DB provider in order to create an ActiveX component that will transform
flat file data? How would you write the ADO connect string code to do so?
I would like to build a very flexible component that will grab a file and
using predefined file specs loaded from a database table and metadata from
the destination db, do a transformation/import into SQL Server. Thanks for