Morning...

I have a current process that uses a ETL Tool Data Junction pulling data from a .TPG file into SQL Server 200

We would like to rewrite this process and use DTS. Does anyone know what kind of file .TPG is and can DTS read it

Thanks for your time.

Hello Brenda;

Welcome to the world of SQL Server and cost saving...we need another group for this!!! ;-)

I am really not sure if DTS can see files with extension .tpg. However, a good exercise to find that out would be to open the DTS designer, add a source text file task and while selecting the path, select the "All Files" option from the drop down box instead of .txt or .csv. Give it a shot.

More often than not, tools like the one you mention, simply have their own proprietary extension but they basically are text files. Should this excercise reveal that it is indeed a file that is specific to the software, you should talk to them about how you can convert that to a text file.

hth,
K

----- Brenda wrote: -----

Morning....

I have a current process that uses a ETL Tool Data Junction pulling data from a .TPG file into SQL Server 2000

We would like to rewrite this process and use DTS. Does anyone know what kind of file .TPG is and can DTS read it?

Thanks for your time.