That's only for quitters 😀

Installing Integration Services does not install SSDT.

You explicitly...

When you check for content of your own website, you get 0% unique content because it finds of course your website.

(and Comic Sans MS?)

Gaaaah, I forgot to tick one of the options.

MOAR caffeine!

On my system, SSDT is located here:

"C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe"

I would just add a shortcut on the desktop and pin it to the taskbar.

No need, the correct answer is actually not so correct 🙂

Try typing SQL in the search of the start and see what pops up.

It's pretty annoying when you have multiple SQL versions and you need to find out which Management...

You're correct. There's an issue...

balasach82 (1/20/2015)

---

Thanks a lot for the quick reply. Yes, I can use DTUTIL to export to folder. Then, from there, should i have to add each pkg, one at a...

Maybe the test script should have created a table with an identity column of numeric(38,0), instead of numeric(17,0).

Hence, the "correct" answer is incorrect.

(I though I was losing my sanity here...

Yeah, that is correct.

You should create some configurations and assign values to them.

In VS, you can switch between configurations using the dropdown.

To be honest, I haven't done this for SSRS...

anthony.rooney (1/19/2015)

---

Hello

Here is what appears to filter as expected.

In DataSet properties Filter I added in the Expression field =IsNothing(Fields!myField.Value)<>TRUE. Changed type to Boolean, Operator to "=" and Value =true.

Remarkabily...

In the data set, the option query type must be set to Text.

Then click Query Designer, which will open the query editor, where you can edit the text.

Luis Cazares (1/19/2015)

---

Note that there are some problems registered when using sp_MSForEachDB. Check the following article for an alternative: http://www.mssqltips.com/sqlservertip/2201/making-a-more-reliable-and-flexible-spmsforeachdb/

You could also build your own solution using a cursor and...

Alvin Ramard (1/19/2015)

---

Koen Verbeeck (1/19/2015)

---

You linked two Boolean expressions together with AND, meaning both must return TRUE in order for the WHERE clause to return TRUE.

However, looking at the first...