Hi coool_sweet,
Got this response from a helpful fellow at MSFT:
"The deployment wizard will extract the ispac and load the package using the current SSIS runtime installed...

Hey coool_sweet,
I'm having the same problem I think, I am using the latest SSMS release (17.4, 14.0.17213.0) and SQL Server 2016 (v13.0.4435.0), and developed the...

jbnv, are you serious about working on an open source version? Do you think it is worthwhile?

I've actually been trying to build a SQL/table based workflow engine with a...

I second the sommarskog.se site (which gretchkosiy 2550 refers to above) - that is an excellent writeup which includes gotchas for SQL 2008 SP1 and dynamic SQL if I recall...

How about something really simple like:

select

case

when (num % 5 = 0 and num % 3 = 0) then 'FizzBuzz'

when num % 5 = 0 then 'Buzz'

when num % 3...

Steve, isn't that always how it goes? 😉

StreamInsight and SQL 2008 R2 should be RTM in May 2010. See this article for more info about the release.

I'm excited about the great new features! It's a...

Actually, for a little while (in SQL 2000) we used to pin tables in memory using the "dbcc pintable" command. It didn't load the entire table into memory by...

Soki,

Thank you for responding and your comments! Here is a slightly different (self contained) example that I think highlights my question better:

--build a temp table with an integer field...

Soki (9/25/2009)

---

Good article

Just a small piece of mind, in regards of the performance, SQL Server supports short circuiting, which can be a MAYOR help if you know what kind of...

dmbaker (9/25/2009)

---

This was a great article, but typically when I start seeing needs like this, I start wondering if maybe a better solution would be to try something completely different....

I wanted to add that I have specifically had some really serious performance headaches with SQL Server's query engine and its handling of SARGS (search arguments), particularly related to OR...

Great thought-provoking article. Nice to think a little outside of the box!

Actually, I have always thought that there are still only the 4 basic functions, Create, Read, Update and...

I recommend Watchguard. They have a slew of high-end all the way down to the low-end devices, some that specialize in only VPN connections, others that are more general...

I'll gladly trade you a cheeseburger today for your pencil w/ Voight bite mark Tuesday.

Taken from the old saying "I'll gladly pay you Tuesday for a cheeseburger today"!

Jon