March 24, 2012 at 10:08 am
In the past when I deploy an SSIS Package I store it in SQL Server as opposed to executing as a File System Object.
What are the Pros & Cons?
What are the advantages to executing it as a file as opposed to storing it in the MSDB Database and executing it as a job?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2012 at 12:08 am
I don't really use the filesystem, as I like the pro's about SQL Server storage:
* packages are secured by SQL Server
* when MSDB is included in the backup policy, SSIS packages are automatically backed up
However, if you have multiple SQL Server instances on one server and only one SSIS instance, it might be useful to store the packages in the filesystem.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 26, 2012 at 2:41 pm
Koen Verbeeck (3/26/2012)
I don't really use the filesystem, as I like the pro's about SQL Server storage:* packages are secured by SQL Server
* when MSDB is included in the backup policy, SSIS packages are automatically backed up
However, if you have multiple SQL Server instances on one server and only one SSIS instance, it might be useful to store the packages in the filesystem.
With some tweaking of the SSIS config file you can store packages in all of the MSDBs available. ..
CEWII
March 28, 2012 at 12:08 am
Elliott Whitlow (3/26/2012)
Koen Verbeeck (3/26/2012)
I don't really use the filesystem, as I like the pro's about SQL Server storage:* packages are secured by SQL Server
* when MSDB is included in the backup policy, SSIS packages are automatically backed up
However, if you have multiple SQL Server instances on one server and only one SSIS instance, it might be useful to store the packages in the filesystem.
With some tweaking of the SSIS config file you can store packages in all of the MSDBs available. ..
CEWII
I know, I read an article about it the day after I posted this reply. 🙂
Good to know.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply