Is that possibly some sort of maintenance window or something like that on the Oracle server? That's what it sounds like to me.

Cool biz.

Also, check the default trace for the server. Are you familiar with querying traces? It should include any drop/create statements for databases, I think.

Since you want to sort by hierarchy, then by the sort order column within the hierarchy, the easiest way to do this is to include the top level ID for...

Generally speaking, you don't want to. You usually do that during quiet periods. The only real use for the data is to determine if you should defrag/rebuild the...

Then it's actively rejecting it for some other reason.

Please don't double-post.

The "clustered index" is, for all intents and purposes, the table itself. I would expect that to the majority of the work on a simple update.

In other words, this...

"the target machine actively refused it" is the key here.

It means the server you are trying to connect to is configured to refuse that connection. You'll need to check...

You're welcome.

Backing up the database does nothing to free up space in the transaction logs. You have to back up the logs specifically to allow them to create checkpoints and...

Are you counting "1/17 is 1, 1/18 is 2, ..."? If so, then that will give you 22, but it's incorrect because 1/17 is not 1 day different from...

You have the step set to fail if any rows aren't matched. That's the default. Change the error handling in the step.

It looks like 21 to me on my calendar. Those dates are exactly 3 weeks apart (Monday to Monday). Why would it be 22?

Do you need to join on the timestamp, instead of the object name? The way you've got it written right now, it'll be a cross join between the two...