December 9, 2010 at 11:11 am
In SSIS Deployment, there is 2 Modes of deployment. first is File system Deployment and another is SQLServer Deployment. Which one is better to Use??
December 9, 2010 at 12:05 pm
I personally prefere msdb deployment. It really depends on how much you want to worry about maintaining backups and the like on msdb vs. using a file system backup, and how easily you want to be able to swap the packages from a file level vs. a re-import to the msdb structure.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 9, 2010 at 12:30 pm
"Better" is subjective, but I use SQL Server deployment into msdb.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 12, 2010 at 11:39 pm
It depends business to business. Largely, if, security of package is a concern opt for SQL Server storage
Raunak J
December 13, 2010 at 10:15 pm
I think Craig hit it on the head.
I personally refer MSDB because I want all my database stuff backed up together and not have to worry about the file system.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply