Here's a slightly different version:

DECLARE @DOB DATE = '20000101';

DECLARE @AgeYears TINYINT = DATEDIFF(YEAR, @DOB, GETDATE());

SELECT Age = (CASE WHEN @AgeYears <= 13 THEN 'Age less than 14'

...

If you right-click on a project in SSISDB, and select 'Versions' you will see a list of previously deployed project versions (the maximum number of versions displayed will depend on...

Just got a spam e-mail that starts with this:

"I am the only Daughter of my late parents Mr and Mrs Nelson Smith. My father was a highly reputable business magnet...

Re1 (9/29/2016)

---

Hi,

I am facing an issue with CozyRoc Table difference. It is passing Unchanged rows (same in both old and new) records into Updated rows (appear in both old...

See link.

I'm interested. Can you explain why, please, in a bit more...

GilaMonster (9/28/2016)

---

You have the latest SSMS...

GilaMonster (9/28/2016)

---

It does (try it, you'll end up with @@TRancount of 1), because of deferred compile.

When the batch is parsed, the...

mcfarlandparkway (9/28/2016)

---

I am new to SSIS,Need some ideas and thoughts of creating XML configuration (dts config) file (Common file) one SSIS package should have capability to load into it.

Researching like...

Rechana Rajan (9/28/2016)

---

Phil Parkin (9/28/2016)

---

Rechana Rajan (9/28/2016)

---

Phil Parkin (9/28/2016)

---

Rechana Rajan (9/28/2016)

---

The transaction is not getting commited or rollback when run in different db. The execution might throw error but its...

I'd suggest that you try adding a merge hint to your MERGE. Start with HOLDLOCK and test ... moving up to TABLOCK if necessary.

You should also take steps to ensure...

Rechana Rajan (9/28/2016)

---

Phil Parkin (9/28/2016)

---

Rechana Rajan (9/28/2016)

---

The transaction is not getting commited or rollback when run in different db. The execution might throw error but its not commiting for below...

Rechana Rajan (9/28/2016)

---

The transaction is not getting commited or rollback when run in different db. The execution might throw error but its not commiting for below

BEGIN TRY

...

quinn.jay (9/27/2016)

---

Phil Parkin (9/27/2016)

---

The error messages mention Teradata and Attunity, so I am assuming that the packages have one or more connections to a Teradata database.

Such connections are not natively...

quinn.jay (9/27/2016)

---

Phil Parkin (9/27/2016)

---

You should consider making some changes, to open things up and get closer to best (or at least, 'rather good' :-)) practice:

1) Use the project deployment model,...