[font="Courier New"]Wish you all a happy new year![/font]

😎

TomThomson (12/30/2014)

---

Eirikur Eiriksson (12/30/2014)

---

I find both human and computer languages a very fascinating subject, must admit that I've been taken aback by the general ignorance here in the UK when...

Jeff Moden (12/31/2014)

---

Eirikur Eiriksson (12/31/2014)

---

Michael Meierruth (12/30/2014)

---

Jeff, so what was the trick?

I guess when you need to execute something only once and it takes 900 miliseconds you give it no...

vamsye (12/31/2014)

---

I'm not calling via script task, this is a regular dtsx package and it does not even have any script components in it.

This pop up comes after the validations...

vamsye (12/31/2014)

---

I'm getting the following pop up message whenever I'm trying to open a SSDT solution.

Note: I have already registered the Dts.dll, but it did not make any change, also...

Steve Jones - SSC Editor (12/31/2014)

---

I think DAS was coined when expansion boxes attached to servers using external SCSI connections. This distinguishes it from storage across a network using HBAs,...

Jeff Moden (12/31/2014)

---

@jesse.owen,

I'm totally confused as to what the purpose of the YearMonth column in the #tab_MonthlyData table is. If you have columnar month data, why is each row...

Jeff Moden (12/30/2014)

---

Eirikur Eiriksson (12/30/2014)

---

I do agree here and this is where things get really interesting, although metaphorically speaking one is indeed entering the forest of great misconceptions. Heavier iron...

Michael Meierruth (12/30/2014)

---

Jeff, so what was the trick?

I guess when you need to execute something only once and it takes 900 miliseconds you give it no further thought.

Still, getting anything...

Quick and slightly hurried example of how to achieve this, mind you it's not a complete solution but should be enough to get you passed this hurdle. (Some) Comments in...

Quick suggestion, should be enough to get you passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.myTable') IS NOT NULL DROP TABLE dbo.myTable;

GO

CREATE TABLE dbo.myTable

(

MT_ID INT...

TomThomson (12/29/2014)

---

Eirikur Eiriksson (12/29/2014)

---

TomThomson (12/28/2014)

---

Here are some more languages people can guess at:-

Nollaig chrìdheil agus bliadhna mhath ùr

Nollaig faoi shéan agus ath-bhliain faoi shonas

Nollick ghennal as blein vie noa

Bonan Kristnaskon...

Jeff Moden (12/28/2014)

---

Eirikur Eiriksson (12/27/2014)

---

Run results

OPERATION ...

That's because of...

Quite few ways of doing this, here are two quick solutions

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_SAMPLE_A') IS NOT NULL DROP TABLE dbo.TBL_SAMPLE_A;

CREATE TABLE dbo.TBL_SAMPLE_A

(

COL_A INT...