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)
 How to use the Dynamic Properties DTS Task?

Author  Topic 

Joozh
Posting Yak Master

145 Posts

Posted - 2005-01-10 : 23:25:12
Hi,

I recently came across a DTS made by an experienced DBA and was impressed by the use of Dynamic Properties DTS Task used. As I understood the DTS was generic and if I'm not mistaken, can be easily transferred to another server/machine on an AS IS basis and without having to change any of the properties (server name, login, password etc.) for the source or destination server.

This seems to be a really neat feature.

I tried to put this to use but am having problems regarding how to proceed... Unfortunately I have not been able to find any article either which addresses this particular request and takes a novice step by step so that this feature can be used.

Will appreciate any help.

Thanks

steffi
Starting Member

3 Posts

Posted - 2005-03-07 : 10:52:27
Try this link:

http://databasejournal.com/features/mssql/article.php/3073161

Go to Top of Page

Joozh
Posting Yak Master

145 Posts

Posted - 2005-03-08 : 07:39:44
Thanks
Go to Top of Page
   

- Advertisement -