Hold up..

You have to do this with an account that has sufficient rights, you can't just add yourself as an administrator if you don't have another account. If that...

That they absolutely can do.. But at least somebody would likely notice that.. just loging in is much more transparent.

CEWII

I didn't get that from what he wrote Steve, could be...

CEWII

Agreed with Phil. What you don't want to do it copy/paste the contents from the control-flow window into the other package.. There will be pain....

CEWII

In 2008 unless you are running it in single user mode the internal security config is in play, and builtin\administrators is not added by default, which means they don't have...

Unfortunately I don't have any insight into that.. Have you goggled it?

CEWII

On a local machine I could go for that. On a server, nope, I would prefer the OS admins NOT have access to SQL..

CEWII

Local users and local system have no security context outside of the local server (local, get it). Therefore when trying to connect to resources on other machines they can't...

If I read your question right. You have a local SQL server but your normal domain login does not have sysadmin rights?

Just add a login in SQL with your...

I think you might be misunderstanding the concept of least privilege. Using a domain account which is just a user is perfectly fine. The problem you are describing...

As I read your response, you are using the last item on that tab, which typically reads: "Be made using this security context:" followed by username/password boxes.

Then the...

Jack,

I can help you with that. I have attached a package that does what you are talking about. There is other stuff there but you get the point....

While I am in general agreement with Koen, the tables I was dealing with tended to require being loaded together, always.

If ALL of the tables are large, and really, 1GB...

I think you misunderstood Ninja's question. There are several security contexts in question here. On a linked server the second tab or item is usually security. What...

Jack,

That is particularly tricky.. If you have an exec package for each I might suggest using a package configuration that easily allows you to repoint the exec component. ...