What is the exact command you are trying to execute?

CEWII

Do you need access to the last value when you are done? If not here is the basic solution:

' Microsoft SQL Server Integration Services user script component

' This is...

Is one of your profiles (or maybe the only profile) defined as the default? If not you might try that..

CEWII

Ok, let me try something and I'll get back to you..

CEWII

From my earlier post:

"The biggest problem with security is apathy and lazyness. FAR too many people use highly privileged accounts for app logins, OR their application is architected in such...

I'm going back to my original question that has yet to be answered, "What else is on this server?"

Also, do you use SQLCLR or sp_OA at ALL?

As others have stated...

Where are you trying to do this?

It feels like a data-flow script component. Why don't you tell us more about what you are doing before I try to answer.

CEWII

Which was going to be my suggestion. As far as pooling, the connection itself is not closed, it is left open and if there is insufficient need then those...

Basically, yes.

CEWII

Then within the F-E-L container do the work, each of the F-E-L containers will run in parallel.

CEWII

Here is the basis..

This gets you to the point you could call the sub packages. Which have to use some "magic" to get the table and filename..

That magic is...

Do they need to be sub-packages? The reason I ask is that it is more complex to explain due to parent package variables..

CEWII

Yes it does.. LEt me do a quick POC..

CEWII

Because reporting services is not cluster aware that isn't likely to work.

CEWII

So you have a table that you want to load into a variable and then iterate through using a for-each-loop. You then want to call a sub-package depending on...