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 |
Olde_DBA
Starting Member
3 Posts |
Posted - 2009-02-03 : 16:11:52
|
Hello: We're trying to figure out how to administer SQL Server 2008 SSIS packages. We'd like to store them *in the MSDB database* for a lot of reasons. However a requirement of our environment is that the developers need to be able to view the contents of the package one migrated to test/prod/etc. The only way I know how to open and view the contents of a package is by opening it *from the file system* when in SS Business Intelligence Development Studio. Obviously any time you have two copies of the same thing stored in two different places human error can cause them to get out of sync. I'm in no means a SSIS package developer and hopefully this problem is just that I don't know how to do it. Can someone point me at how to open and view the contents of a package stored in the MSDB?ThanksYe Olde DBA |
|
|
|
|