Thanks....

At least I know I'm not going mad....:-)

Excuse my ignorance (I don't do masses with SSIS other than moving data overnight from one database to another), but what is wrong with this....

1. start a package that checks...

Yup. You got it...

He wanted to make the analogy to the biblical '10 commandments' but he actually had 11 points to make, so squeezed another one in as 5a.

I don't think it's any...

Meaning....

Take your time. Don't rush into a fix with a 'knee jerk' reaction, like politicians who rush into changing a long-standing law, just because something bad happened. Think about it...

I figured the (.5) was 5a....

I would add no 11.

When given a new piece of work, study the requirements, then do nothing for a while. Step away from the keyboard (again!). Lean back in your...

Hi

I got tech. support involved in the end to look at why the job was taking so long to run on the new server.

It turns out that there was a...

Hi

I added code to the sp last night set ARITHABORT and QUOTED_IDENTIFIER.

It has just finished after 3 hours 10 mins!

It ran in 50 mins on the old server and ran...

Thanks

I've added the 2 lines to the sp, so will see what happens tomorrow, though I have checked the old server and got the same results as on the new...

Thanks

I've added the 2 lines to the sp, so will see what happens tomorrow, though I have checked the old server and got the same results as on the new...

Ok, thanks guys.

On my connection I get '5496', whereas in the job it is '5176.

The diff being that my connection has ARITHABORT and QUOTEDIDENTIFIER switched on.

I'll try and change these...

Thanks, Grant

Your earlier message must have arrive while I was typing last time.

Thanks for the input. Makes sense and is certainly worth a look.

I'm checking the settings from SSMS (for...

Hi Howard

Thanks for your reply.

I'm not sure how/why set options would make a difference (as it happens, the sp I'm looking at at the moment doesn't have any) since the...