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

If you have changed the database in the UDL this is not reflected in the
transform task, so if the Source on the task is shown as
[database].[schema].tablename], then you need to change it in an ActiveX
script so that the [database] portion reflects the actual database being
used.

I normally have an ActiveX script that initialises this property by simply
removing the first part of a 3 part path, but only if it has 3 parts - that
stops it going wrong on the 2nd and subsequent executions

"Patrick" <patl@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3E380692-048A-45B9-844A-B4AB38A3751B@xxxxxxxxxxxxxxxx
> 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: Copy SQL Server Objects Fails for certain views
    ... Backup/Restore as transparent to the customer as our DTS package currently ... Our customers don't typically know a database from a monkey wrench. ... Copy objects just uses an alphabetical order. ...
    (microsoft.public.sqlserver.dts)
  • Re: Insert Error: Column name or number of supplied values does no
    ... I did use a log file which gets the following: ... As to running interactively, if you don't mean using the database wizard, I ... > table structures are different between your prod and dev SQL Servers. ... > Can you run the DTS package interactively and see on which table you are ...
    (microsoft.public.sqlserver.dts)
  • Re: Advice sought on use of DTS [Long]
    ... it may help to know that you can disable triggers temporarily do ... You may want to set up a sql job to copy over the remote database (the ... Can you programmatically tell a DTS package which databases to update? ...
    (microsoft.public.sqlserver.dts)
  • Re: Help with dtsrun and dts package.
    ... I dropped the tables from the database and that took care of the table ... The SQL server 2000 being used to create the dts package is on a different ... the MSDE master database but the message is that you cannot restore a SQL ... Can I create a dts package without using SQL 2000 Enterprise manager? ...
    (microsoft.public.sqlserver.odbc)
  • Re: Recordset closes for no reason
    ... A UDL is a Universal DataLink file used to connect to database. ... Right click on your desktop and use the context menu shortcut to create a new text file. ...
    (microsoft.public.dotnet.languages.vb)