Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Dynamic Properties in DTS Package

Author  Topic 

jgmcrae
Starting Member

2 Posts

Posted - 2005-01-17 : 16:01:29
I am trying to use an .INI file to dynamically change my Connection Properties within DTS packages. I am using the dynamic properties to read my .INI file before running my package. However I have some packages that contain no source file, but have SQL that needs a server connection property to run properly. How can I use a dynamic property (.INI file) to change the properties of my connections for movement between environments? Thanks for any help.

jgmcrae
Starting Member

2 Posts

Posted - 2005-01-25 : 16:35:12
BUMP
I need an answer please
Go to Top of Page

steffi
Starting Member

3 Posts

Posted - 2005-03-07 : 07:22:49
Try this link:

http://databasejournal.com/features/mssql/article.php/3073161
Updating SQL Server Connection Properties from the DTS Package INI File

Good luck!

Go to Top of Page
   

- Advertisement -