Monday, June 24, 2013

[SQL 2012] Intermittent Failures with new 2012 SSIS Job

[SQL 2012] Intermittent Failures with new 2012 SSIS Job

Intermittent Failures with new 2012 SSIS Job

Posted: 24 Jun 2013 01:58 AM PDT

Our team has several jobs in production using the old package deployment model. They have been running successfully and we haven't had any issues. However, we recently developed a new job that uses the project deployment model in SSIS 2012. It's a quick job that typically takes less than a minute. We set it up to run at 6:00 and 6:30 and it never fails consecutively. Since the beginning of the month, it has failed at: -6/22 at 6:30 -6/18 at 6:30 -6/16 at 6:00-6/13 at 6:00 -6/11 at 6:00-6/10 at 6:00Every other day and time not listed, it ran successfully. The job calls a few SSIS packages and processes a cube. The logs for the failures give almost no information. All that it says when it does fail is, "ended unexpectedly." When the failures occur, they are at different stages in the job and can happen after 6 seconds, 8 seconds, or 10 seconds, it appears to be completely random.I know this is kind of a shot in the dark, but has anyone experienced similar problems with the new project deployment model? Any tips or ideas for ways to resolve the failures?

how make online index

Posted: 23 Jun 2013 11:02 PM PDT

Hi,I want online index rebuild on all datbase in server

Tablix width changing when expanding field

Posted: 23 Jun 2013 10:26 PM PDT

I have a tablix with the middle column text hidden until the left column is expanded. All the text fits, but when I click the expand "+" the whole tablix width expands, cause other items on the report to move with it. Strangely, it never happens for the 1st row, but for any other row the problem occurs. There's no reason for it to widen, as there's no text which is longer than the fields. I've tried with 2 different browsers and I get the same problem. However, it doesn't occur in the "Preview" view in BIDS/Data Tools.

sql 2012 mirroring using sql xpress as witness

Posted: 23 Jun 2013 09:19 AM PDT

Hi,I'm trying to set up mirroring between two sql server 2012 instances and use sql server 2012 xpress as the witness. the primary and secondary instances do not see the xpress instance, which is a vm btw. but the witness sees the primary and secondary, kinda like a compatibility issue. Can i use xpress as a witness when setting up sql server 2012 mirroring? all are in the same domain.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog