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.
| Author |
Topic |
|
the1gadget
Yak Posting Veteran
55 Posts |
 Posted - 2005-12-20 : 07:43:45
|
| Hi AllI know I have this some where but I can not find it.I want to copy a set of DTS packages from one server another. I know it can be done but I for got to book mark it.-- David |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-12-20 : 07:54:54
|
| Generate script of DTS from your VSS (you DO put thenm in a VSS??)Apply script to new server |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-12-20 : 07:55:52
|
| You may even be able to open the package and do Save As to the other server. |
|
|
|
the1gadget
Yak Posting Veteran
55 Posts |
Posted - 2005-12-20 : 08:35:33
|
| No that was not it.I am sure that you create a DTS package linking the two servers.I will keep on looking. |
|
|
|
the1gadget
Yak Posting Veteran
55 Posts |
Posted - 2005-12-20 : 08:41:29
|
| When I did it I ran a query like.==============================8<==============================SELECT T1.* FROM dbo.sysdtspackages AS T1INNER JOIN (SELECT [name], [id], MAX([createdate]) AS [createdate] FROM dbo.sysdtspackages GROUP BY [name], [id]) AS T2ON T1.[id] = T2.[id] AND T1.[createdate] = T2.[createdate]==============================8<==============================From inside a DTS package. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-12-20 : 09:57:28
|
| That's not how to transfer them. Follow Andrew's advice or mine first. |
|
|
|
|
|
|
Copying DTS fron one server to another