Is there an easy way to change the source path for a DSN using the DTS
object model?

I have a DTS to import DBFs into SQL. Because I want to do some complex
join queries with the DBFs while importing I cannot use the native dBase
connection object. I am using a DSN with the Visual Fox Pro Driver.

The source path changes on a daily basis. The path name is based on date.
Renaming the path to something fixed is not an option due to parrallel
processes. Copying the data to a fixed path is not an option due to the
volume of data. I need to dynamically change the source path of the DSN.

I came across VBscript code to change the source path of a system DSN by
creating a reference to a shell script object and playing around with the
registry. I could alternatively use file IO code to update a file DSN. What
I am hoping for is an easy way to change the source path of the DSN using the
DTS object model.

Is this possible?

Thanks.

Paul

Here is an example where you can get the idea.
http://www.sqldts.com/default.aspx?200
Rgds
JFB

"Paul" <Paul (AT) discussions (DOT) microsoft.com> wrote

Thanks for the reply. I have seen and used that code before. However it
does not work on an ODBC DSN connection object in DTS. The DataSource
property simply changes the name of the DSN you are using. Any other ideas?

Thanks again.

Paul


"JFB" wrote:

Ok Paul maybe the easy way is to use UDL connection. It's easy to replace
the file...
JFB

"Paul" <Paul (AT) discussions (DOT) microsoft.com> wrote

Excellent. That looks like what I need. I never used UDL connections
before.

Thanks for the help!

Paul

"JFB" wrote: