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 |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2013-04-24 : 13:43:36
|
| hi, I'm building some "Good practices" guidelines.For SSIS, I prefer keeping the package files on the database server under a folder named "SSIS Packages". And they don't reside in folders that are someone's name. This way, when a developer leaves, nothing has to be moved etc.I want to check with other professionsal to get your opinions on the best options for storing the SSIS package files.Thanks for your ideas. Jack |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-04-25 : 00:53:14
|
| We store them all in msdb. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-25 : 01:04:09
|
| you can store it in msdb folder by importing packages to integration services instance. Keep the protection level of packages to rely on server storage. The deployment utility can be created from visual studio project which will create a manifest file which you can click and do the deployment yourself in the required server.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2013-04-26 : 11:35:18
|
| Thanks to both for your replies. When importing, I also store them in msdb.But I was asking where do you save the packages physical files when developing the package? I use a path on the database server C:\SSIS PackagesAny thoughts?Thanks, Jack |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-29 : 00:48:37
|
| we usually put them in a version control mechanism like VSS------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-04-29 : 11:16:49
|
quote:
Originally posted by visakh16
we usually put them in a version control mechanism like VSS------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
Same here |
|
|
|
|
|
|
Storing SSIS Package Files