July 18, 2013 at 12:01 am
Comments posted to this topic are about the item Resolving Errors While Connecting to SSIS
July 18, 2013 at 8:35 am
Very useful article. Especially for those who don't spend a lot of time dealing with SSIS, and need to debug something a couple of times a year.
July 18, 2013 at 11:34 am
There is a problem with item 16. The db_dtsadmin from 2005 was replaced by db_ssisadmin in 2008. The problem dbas need to be aware of is that a member of db_ssisadmin has the ability to elevate themselves to the full sysadmin role. Not good. Instead, add the group or account to both the db_ssisltduser and db_ssisoperator roles. Strikes me as a pretty serious flaw which should be addressed by MS, but this behavior still exists in 2012 version.
Bob Feldsien
July 18, 2013 at 1:35 pm
This is a very nice copy of this MSDN article:
Connect to a Remote Integration Services Server
Didn't notice the copyright at the bottom?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 18, 2013 at 2:37 pm
// accidentally hit quote instead of edit... :blush:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply