Check to see if that account has the right to execute packages.

I would recommend you use Profiler.

I would also recommend you go to Books Online and read up on using Profiler.

When do you get the error with the SQL account? When you connect? Or when you try to execute the package?

WOW, he got the hint!!!

I'm guessing we haven't seen the last of this.

jcrawf02 (2/25/2009)

---

*sniff *sniff - smells like fish in here. :hehe:

I think perhaps what we're looking for are a couple of questions that need to be answered as part of the...

Couldn't resist. This should be post 2000!!

hmmmm.....

First there was The Thread.

Then came Son of the Thread.

NO!!!!!!

Yesterday was an interesting day on here. I don't think any of the posters were picked on, except for a quick reference to a White.house employee.

If the answer to this question...

May I ask what?

I'd recommend doing what Matt AND RBarry recommended, if you can.

Will you ever have a situation where both the pre 2008 and the 2008 onwards dataflows both get executed during the same run?

Sounds like a self fulfilling prediction to me.

I need to know why do you have that dataflow disabled before I suggest a solution.