SQL Server Performance Forum – Threads Archive
How to use the Dynamic Properties DTS TaskHi, 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
http://databasejournal.com/features/mssql/article.php/3116201 andhttp://www.sqldts.com/default.aspx?252 links will help in this regard. HTH Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Many thanks satya. Appreciate your reply and help. For the benefit of other readers of this post, I also came across the following article and this too was helpful: http://www.databasejournal.com/features/mssql/article.php/3073161 Regards.