Re: Reading UDL files in DTS package- not working!!

Tech-Archive recommends: Speed Up your PC by fixing your registry

The UDL file itself is something like:

[oledb]
; Everything after this line is an OLE DB initstring
Provider=MSDASQL.1;Password=password;Persist Security Info=True;User
ID=userName;Extended Properties="DRIVER={MERANT 3.60 32-BIT
Sybase};UID=userName;DB=testDB;SRVR=DSRV0002;PWD=password";Initial
Catalog=testDB

Why can't my DTS package just pick up changes to this file without having to
re-open and re-save the DTS package, having ticked the correct tickbox!

"Paul Smith" wrote:

> Are you using DSN less ODBC connections? If not you may need to set the ODBC
> values in the control panel
> "Patrick" <patl@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:ugc86DrTFHA.2756@xxxxxxxxxxxxxxxxxxxxxxx
> >I have a few DTS packages in SQL Sever 7.0
> >
> > Each have a Data Transfer Task with a Sybase 11 ASE database as a data
> > source and the SQL 7 table as a destination.
> >
> > The Data source are defined using a Microsoft Data Link File (UDL), and
> > the actual connection is via ODBC (Merant Sybase Driver) as specified in
> > the UDL file. I have ticked the box which says "Always read properties
> > from UDL file". However, when after I have changed the UDL file to which
> > the DTS was set to read, the DTS when executed (using dtsrun) is still
> > using the old connection settings. This is unless I open up the DTS file
> > with Enterprise Manager's DTS designer and re-save the package? How could
> > I fix this?
> >
>
>
>
.

Relevant Pages

  • Re: Reading UDL files in DTS package- not working!!
    ... Are you using DSN less ODBC connections? ... > from UDL file". ... > the DTS was set to read, the DTS when executed is still ... > using the old connection settings. ...
    (microsoft.public.sqlserver.dts)
  • UDL for Text Files
    ... For some reason, importing text files into Access seems ... The easy thing would be to set as a link table in Access, but DTS ... I don't find a way to create a UDL file for text data. ... stable at importing than SQL Server! ...
    (microsoft.public.sqlserver.dts)
  • Re: How to obtain "data source" from within ActiveX/VB?
    ... www.SQLDTS.com - The site for all your DTS needs. ... >I have an activex object in a DTS package which contains hard-coded info ... > from the UDL file that appears to contain the value I want. ... Data Source appears to be the same as the ...
    (microsoft.public.sqlserver.dts)
  • Re: Executing DTS C#
    ... That DTS Package works ... >> public string serverName; ... >> private void InitializeComponent() ...
    (microsoft.public.sqlserver.dts)
  • Re: Open File Dialogue within DTS Package?
    ... Multiple QA folks have to run the DTS package. ... >Connection1 to Connection2 that consists of a Transform Data Task. ... assign it to the text file connection. ...
    (microsoft.public.sqlserver.dts)