April 5, 2019 at 11:43 am
We used to have all SSIS packages in files systems. As I'm upgrading them to the new server, I'd like to see your opinion where to store these packages, File System to MSDB? what's the pos and neg ?
April 5, 2019 at 11:49 am
I assume your not upgrading to SQL Server 2008 (which is the forum you've posted in). If you are, you need to reconsider as 2008 is about to run out of support.
To answer your question msdb or File System, the answer is neither; use SSISDB, it's a huge improvement on the deployment model. You can find out about it here.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 5, 2019 at 12:03 pm
We are on 2008 going to end up on 2016 what exactly is SSISDB and how do I create it?
Thanks
April 5, 2019 at 12:18 pm
We are on 2008 going to end up on 2016 what exactly is SSISDB and how do I create it? Thanks
It's all covered in that link I posted above, including how to create it. You'll probably be better having a look there and then asking about what you don't understand as there is a lot to learn.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
April 7, 2019 at 4:08 pm
In the 2008 R2 release they introduced SSIS project deployment model which uses SSISDB. Only the package deployment model is available in the 2008 release.
SSISDB was added in 2012, not 2008 R2.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply