sql server dts: DTS Import text file -- sql server dts

DTS Import text file

Mike P.
6/28/2004 7:23:34 PM

sql server dts:

I have SQL Server 2000 Enterprise Edition with SP3A. I
have set up a DTS job to import Windows 2000 Advanced
Server performance monitor output values from a text file.

Connection1 is a text file: E:\Server_dd_yyyymmdd.txt

Connection2 is a OLE DB Provider Connection for SQL
Server: Performance_Data (Table Name)

How would I modify the job so that it will recognize the
text file naming convention (E:\Server_dd_yyyymmdd.txt)?

This would be a very big help to resolve this issue.

Thanks,

Re: DTS Import text file

Allan Mitchell
6/29/2004 10:22:36 AM

Wouldn't it be nice if we could have a placeholder type function for this?

Unfortunately there isn't one so we have to roll our own.

Have a look at this

How can I change the filename for a text file connection?
(http://www.sqldts.com/default.aspx?200)

Allan

[quoted text, click to view]