Viewing 14 posts - 1 through 14 (of 14 total)
At least I know I'm not going mad....:-)
October 10, 2014 at 8:06 am
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...
October 10, 2014 at 2:07 am
Yup. You got it...
September 18, 2014 at 5:19 am
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...
September 18, 2014 at 4:56 am
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...
September 18, 2014 at 4:42 am
I figured the (.5) was 5a....
September 18, 2014 at 4:14 am
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...
September 18, 2014 at 4:02 am
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...
May 25, 2012 at 2:23 am
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...
May 23, 2012 at 2:31 am
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...
May 22, 2012 at 7:02 am
May 22, 2012 at 6:58 am
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...
May 22, 2012 at 6:31 am
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...
May 22, 2012 at 5:42 am
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...
May 22, 2012 at 4:34 am