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...

Someone stop the presses! Computer Nerds are acting like Geeks!

It's the end of the world.... :alien:

I've already checked "fails for me too" on this. But give me a few to finish catching up at the office and I'll see if I can get this to...

Sorry I didn't get back sooner. I got swamped.

AutoHide was indeed the problem. Thanks for your help, John.

Hi. Let's try this again.

I don't HAVE SSIS Properties. See attached.

GilaMonster (9/7/2011)

---

Agreed. I made a few snide replies to his more vicious posts over at...

I don't have that path in my VS....

Tom,

I was able to reinstall SQL 2000 client tools after my 2k5 upgrade. I had to use a different install path, but the install worked... And so did the tools.

Maybe...