Ah... Jeremy beat me to it..

AWE is not relevant for 64-bit.. So no matter what it is set at it is ignored..

CEWII

If you have a set number you want to text you could just use Database Mail and send an email to the phone. For sprint it is usually 3335551212@messaging.sprintpcs.com....

What you are describing sounds a lot like "intra-query parallel thread deadlocks". I am working on a similar problem..

CEWII

You are very welcome.

CEWII

I think you will have to allow the package to start, HOWEVER, you can add a script right at the beginning to determine whether to go on with the process....

Both 2005 and 2008 handle passwords the same way if the protection level is set the same, so I don't think that is the basis for the problem. However,...

Ok, I'm actually guessing you didn't wait long enough on validation. I have seen some obscene validation times on a couple packages.

So you had a 2005 package that you...

Wayne,

I'm a little fuzzy on how you are moving them can you clarify? When you say you setup the data sources the same, please clarify.

Also, verification can only be...

Ok, I could see that.. Unfortunately I see so many bad practices I just have to assume its real.

As far as a 64-bit connecting to a 32-bit or vice...

I seemed to remember that the SQLAgentOperator should allow them do access other's jobs. Because normally they would have access to theirs anyway.

As far as SOX, it rarely ever...

I think Brian might be right. But the bigger question is why do you want to let them do this without your intervention?

CEWII

Looks like an interesting product. Not sure I like their pricing structure though.

CEWII

Attached is a package. Pay particular attention to the expression on the remotedb connection. The package takes a query that generates a list of servers and the for-each...

Not to put too fine a point on it, but this thread is nearly 2 years old..

CEWII

You are welcome.

CEWII