"Chris Marsh" <cmarsh@synergy-intl.com> wrote in message
news:ejL%23bI2GFHA.3624@tk2msftngp13.phx.gbl...
> Hi,
>
> I have created a DTS package that I am running from our SQL server. It
> works really well however I would like to be able to rename the both the
> starting Visual FoxPro Database (importing from) and the destination SQL
> database (importing to) globally. This way I could move the DTS file to a
> clients server easily and run the import process there. However, I am
just
> unsuccessful at this unless I create a VB file which I don't want to do.
I
> really like the SQL / DTS package tools and find it pretty easy to
utilize.
>
> Any assistance would be really appreciated, I have about 260 tables and
250
> different customers that I will be doing this with over the next year.
> There must be an easier approach that my current methods.
>
> Thanks,
>
> Chris
>
>

"vjimmers" wrote:

>
> That's great info about the UDL file but how bout the original
> question?
> How to change a connection. Since you suggested UDL connections how
> can we change all of connection 1 (Server Connection) to connection 3
> (UDL connection).
>
>
> --
> vjimmers
> ------------------------------------------------------------------------
> vjimmers's Profile: http://www.dbtalk.net/m171
> View this thread: http://www.dbtalk.net/t162873
>