My system consists of about 20 DTS packages. I would like to install the DTS packages on multiple (around 100) laptops which are operated by salesman who are not too well versed with SQL Server environment. What would be my best option ?
Check this SQLDTS link http://www.sqldts.com/default.aspx?6,105,242,0,0 to accomplish the task. HTH _________ Satya SKJ Moderator SQL-Server-Performance.Com
As per your suggestion, I am trying to use the object model and the method<img src='/community/emoticons/emotion-7.gif' alt=':S' />aveToSQLServer to individually save each DTS package to the destination SQL server.<br />However, if the package already exists, I need to overwrite it retaining the same name.
Also check this link http://www.sqldts.com/default.aspx?t=6&s=105&i=204&p=1&a=0 for transferring dTS packages. _________ Satya SKJ Moderator SQL-Server-Performance.Com