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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2010-10-27 : 08:03:12
|
| what do you prefer,file system or MSDB?i have same 2 enviroments (DEV AND PROD)my packages is the same (except the name of the server)*in the file system i need to copy the file to diffrent target*in the msdb i need to choose file->save copy of package as..i can to run some query in the msdb about the package??? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-28 : 00:47:51
|
| i prefer msdb. makes backup/restore easy. and i like the built-in sql server security this way.you can query sysssispackages for those stored in msdb, |
 |
|
|
|
|
|
deploy package