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 |
|
ladiaocb
Yak Posting Veteran
57 Posts |
 Posted - 2005-01-24 : 12:33:33
|
| I have a dev SQL server with roughly 20 DTS packages. I am going to create another SQL server identical to this one and I want to migrate those same DTS packages to this new one. I know that you can do this by using the sysdtspackages table. However, I want to the data to insert into the new DB. By copying the sysdtspackages table, it will still have the old Source destination. Is there any way to migrate all those packages and update the source destinations without doing it 1 by 1? Please help! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-01-24 : 12:47:46
|
| I normally write dts packages with either a loader that sets all the properties within the packages depending on the environment or set global variables in the package and have a dynamic properties task / activex script within the packes to do it.Given that you ae trying to retro-fit it maybe the first option would be easier but it may mean changing the packages to standardise things.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
ladiaocb
Yak Posting Veteran
57 Posts |
Posted - 2005-01-24 : 12:56:57
|
| What type of loader can you use to set all properties within the package? Is it a third party or build in function? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-01-24 : 13:07:42
|
| You can access all the properties in a package and set them from an app.I sometimes write it in t-sql but it is easier in VB (you could even do it from a dts package probably).Seehttp://www.mindsdoor.net/DTS/ScriptDTSproperties.htmlFor accessing most of the properties of a package==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Migrate DTS packages