January 27, 2010 at 11:56 am
Is there any differences/ benefits if i run my SSIS packages through the package store or file system or Database?
January 27, 2010 at 12:27 pm
I store them in the database, so they get backed up along with the jobs that call them, when I back up the system databases (msdb to be precise).
- 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
January 27, 2010 at 12:58 pm
I agree with what GSquared said. In Addition to that there are some trade offs.
The File System is nice bcause you can use "xcopy" deployment (just copy the pacakge files to the desired location). But it doesn't get backup with MSDB. With the MSDB store you can use mangement studio or a command line untility call dtutil.exe that you can script so that it is almost as easy as xopy deployment. I'm not sure if the utility has been updated, but it used to have issues with certian package names, FYI.
My preference is the MSDB package store. But, which to choose depends on your needs and your environment. There are security trade offs and such. I'm sure you'll get some good responses here, but you might want to do a search for MSDB versus File System and see what pops up....
Cheers!
February 4, 2010 at 4:33 am
MSDB lives under 'SSIS Package store'
If you select to save SSIS packages in MSDB, it will actually save it inside the MSDB database.
Drill down to "msdb>Tables>System Tables" and you'll see below tables, this is where the packages live:
dbo.sysssislog
dbo.sysssispackagefolders
dbo.sysssispackages
If your MSDB is clustered it'll be on you cluster drive.
Hope this helps
Hafiz
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply