You have numerous configuration management options in SSIS. Personally I like using XML Package Configuration files for this kind of work. When I deploy a package to 'dev' or am...

Is the SQL Server Browser service running?

Sorry, that was an extension of my view and your position. By willfully enabling xp_cmdshell, your position, you have made it easier to be attacked, my view, therefore you are...

This describes what you're running into:

Connect > Default Schema for Windows Group

Jeff Moden (9/21/2012)

---

opc.three (9/21/2012)

---

Jeff Moden (9/21/2012)

---

opc.three (9/21/2012)

---

Yikes. The more we talk about this the more your approach to security sounds like 'why bother.'

I am actually becoming quite astonished that...

I am running out of ideas so I re-read the whole thread. Something says to me this is related to Windows Group membership and possibly membership in multiple groups.

I know...

Jeff Moden (9/21/2012)

---

opc.three (9/21/2012)

---

Yikes. The more we talk about this the more your approach to security sounds like 'why bother.'

I am actually becoming quite astonished that you're trying to...

Forgive me if we're covering already covered ground. I am trying to follow along.

Is it to say that you created a new login on the named instance for domain\user3?...

FEL will operate sequentially. You could add additional FELs and have all select a mutually exclusive subset of the packages you need to execute.

You can have a single Data Flow copy multiple tables.

Are there any diffs between the privilege or permission_path when you run this against each principal?

EXEC sys.xp_logininfo

@acctname = 'domain\user1',

@option = 'all';

EXEC...

I would have more questions. Here are a couple options based on the answers to the questions.

- Can the entire file fit comfortably in memory? If so then in Data...

😛 sorry, no harm meant

I would look for high CPU queries using the initial post, there are lots of queries online for this. Proving it to the vendor is always...

jporgy (9/21/2012)

---

So Give this, is it fair to say that the auditors simply need to look at the OS level security policy because it should take effect on the SQL...

What does that have to do with identifying the problem?

It's possible it is related...