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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SSIS Packages - view contents from MSDB Package?

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?

Thanks

Ye Olde DBA
   

- Advertisement -