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 |
|
james_yoder@hotmail.com
Starting Member
9 Posts |
 Posted - 2003-10-07 : 17:24:02
|
| I am currently moving a development database to a Production database. I have the actual database moved, but there are some Meta Data Services Packages located in the Data Transformation Services folder of the development server I would like to move to the production server. Does anyone know how I may go about doing this?Thanks for your help.James |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-07 : 17:28:16
|
| I know how to do it with regular DTS packages, so maybe it will work for your situation too. Just open up the packages, go to Save As... Then you can select SQL Server or structure storage file. If you select SQL Server, then just select the development server name. Then close it and go over to your development server and you'll find it under Local Packages. If you select the other way, copy the file to the development server, then go to Data Transformation Services, right click, then open package...Tara |
 |
|
|
james_yoder@hotmail.com
Starting Member
9 Posts |
Posted - 2003-10-08 : 04:53:02
|
That did it!Thanks Tara! |
|
|
|
|
|
|
Copy/Move Meta Data Services Packages