Not exactly.  From the all executions report and other catalog messages I was able to determine that it was crashing on the data flow with all previous tasks ending successfully.

There...

Yeah, um, i still may have been wrong, but if the question...

First, stupid question but why does your SQL have < 9 and your expression < 8?

Second, what happens when you replace the null function with a default string like "Null...

Yeah this sounds like more of a network set up issue than an SSIS issue.

Is there a reason you want to use the IP though? Its like the old...

Now 99% sure this is a windows update issue. Now just have to figure out which update.

Thanks, Microsoft!

Seems to be causing an APPCRASH on Kernelbase.dll when run from VS

SELECT A. Date, MIN(B.DatePlus3BusinessDays) DatePlus3BusinessDays

FROM TableA A

LEFT JOIN (Select DateKey, LEAD(DateKey,3) OVER (PARTITION BY IsBusinessDay ORDER BY datekey) AS DatePlus3BusinessDays FROM Calendar WHERE IsBusinessDay = 1) B ON A.DateKey <=...

I mostly agree with the above.

You can't do an IN and LIKE with that Syntax.

If you could, it would not really be better than the OR solution, as neither is...

Well he does reference T2 twice which is likely why he bothered (it is in the correlated subquery).

Then again, he probably shouldn't be doing it that way anyway (or at...

EDIT: disregard original solution. This is actually far messier than I first thought.

It would really help if you gave us DDL for the tables, sample data and an explanation of...

In effect, yes.

After you set the isolation level, a query will not...

Yes, it does take extra CPU power.

Parsing a string according to some flexible rules depending on variable environment parameters is not a cheap process.

It's better to do it once and...

But parsing one string before dialling a number takes "Too much of extra...

Sergiy (5/6/2015)

---

So, we have 2 options here.

1. Parse the entered string once when it's being saved into predefined components and store those components in the class.

2. Parse the entered string...

Sergiy (5/5/2015)

---

Google's common Java, C++ and JavaScript library for parsing, formatting, storing and validating international phone numbers. The Java version is optimized for running on smartphones, and is used by...