sqlnaive (8/22/2013)
Hello SSIS Masters, I'm currently going through the learning phase. I have two questions regarding package deployments:Q1. What is the ideal mechanism to deploye the packages (and which one is GENERALLY fllowed across organizations) :
a. By using deployment utility
b. From within BIDS or Management Studio
c. From a command line using dtutil or xcopy
Q2. Where should you ideally place the your packages (and where are these GENERALLY stored across organizations):
a. in msdb database in SQL Server instance
b. in SQL Server instanceb. in file system
The question might seem foolish but i'm new and any clarification will help.
Q1: c. You can script out a deployment with dtutil in a batch file. The deployment utility might be an option, but I never use it myself. Certainly not from BIDS (which is only possible if you install BIDSHelper by the way, or if you use SSIS 2012).
Q2: a. Definately in the MSDB database (this is a personal choice. There's no right or wrong here). The advantage here is that the packages are protected by SQL Server security.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP