Ray K (9/14/2011)

---

True story: a few weeks ago, I was administering a final exam (I teach part-time). One of my students asked a question. It went something like...

You rock, Dave23! Your Google-Fu is superior to mine.

That actually worked. I moved my Toolbox and no error when I closed BIDS. I open it up and it's exactly where...

After experimenting several times, I finally noticed a pattern. If I close BIDS out as normal (without moving the Toolbox), everything shuts down fine, no issues.

If I move the Toolbox...

Are you having the same...

Howard, that's brilliant! It worked.

Thank you so very much. I was about to start developing in 2005 and then upgrade.

And yet, it's not permanent. The Toolbox keeps moving back to the bottom of my screen when I restart VS.

This is annoying!

Bleargh. I hate using the Wizard. It always gets things wrong.

Edit: Thanks for the suggestion, though.

So far as I know, you can't.

You could test rebuilding various indexes, though, and break the job up into smaller parts, only running one of those parts each day. That...

Jack Corbett (9/8/2011)

---

You don't have a package configuration somewhere that is overwriting the design-time value do you? It sounds like that could be it since having a different name...

Already saw that MSDN post last week. As I mentioned it in the first post of this thread, I didn't find anything when I searched for it.

Unfortunately, I can't...

Best wishes for your father, Jack. I know how you feel. I have close relatives who trip just by looking at a corner and are breaking all sorts of things...

I've narrowed it down to a name change issue.

If I leave the connection manager named ServerName.DatabaseName, it stays as the 10 client. But as soon as I remove the servername...

You just lost me.

The SSIS package is being developed on my local box, then loaded up to the Server that it is run on. My local box is 32 bit....

SQL 2008 SP1

---

Msg 3316, Level 21, State 2, Line 135

During undo of a logged operation in database 'Remi', an error occurred at log record ID (101945:2157:177). The row was...

Okay, I did find that setting, prvmine. Changed it. Saved the project, uploaded the package and the job failed again with the same error.

So I checked out the package, saved...