June 2, 2009 at 1:35 pm
What is the best place to save ssis packages, in a file system or in msdb database of sql server by that way pkgs will be backed up along woth database.
If i deploy pkgs into sql server, can i open those in visula studio from msdb if i need to edit anything or do i need to have a copy of physical project file in a file system.
June 2, 2009 at 3:31 pm
Opinions vary about the best place to store packages. I prefer saving them as files in a specific directory and making sure the directory is included in server tape backups. I also keep packages in Visual SourceSafe.
You can edit a package stored in msdb in BIDS by importing it from SQL Server. You don't have to save it to a file then open it in BIDS.
Greg
June 2, 2009 at 4:28 pm
I think that it depends on your Deployment and Maintenance scenarios.
As Greg mentioned, I prefer files so that I can more easily use VSS with them.
If you are deploying to a single SQL Server and running in SQL Agent, then MSDB is probably the easiest and most of the SSIS tools seem to work more conveniently in that approach.
However, if you are deploying to many SQL Servers, or you are in a Corporate environment that mandates the use of an Enterprise Scheduler instead of SQL Agent, then I find it much easier to just stick with files and write my own deployment and execution utilities.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
June 3, 2009 at 11:52 am
that means if i import any pkg from msdb and edit it in BIDS then does the change also effect original pkg in msdb database or is it a local copy at BIDS.
June 3, 2009 at 1:02 pm
You have to redeploy it to the server.
Greg
June 3, 2009 at 1:31 pm
If i have a single pkg in msdb , can i use it for multiple jobs simultaneosly.
what I mean is i have a pkg where in 3 jobs use it, what happens if istart all 3 jobs at the same time which uses the same pkg.
June 3, 2009 at 2:18 pm
I've never had problems executing a package simultaneously. I suppose it would depend on what the package does, though. If it needs exclusive access to something, a file say, there might be some contention.
Greg
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply