How hard did you try?

How about this.

Jason-299789 (2/18/2015)

---

Ok, I would ask why the change from SSIS to SQL.

IN SQL check out the HASHBYTES function.

eg

SELECT

COL1,COL2, HASHBYTES('MD5',COL1+'|'+COL2+'|')

FROM aTable

One other thing there's no guarantee that you will...

Nice article Andy. I have never seen it all set out so clearly before, well done.

I am not familiar with the verb 'chive'. What do you mean?

This is not a valid SQL datatype.

What would you expect?

Guitar_player (2/17/2015)

---

I am Sorry Phil, if at all i hurt you !!!!

but my check is that if we are really looking for the difference then this should be the output...

Guitar_player (2/17/2015)

---

Hi Phil,

Your query looks good..but can u check with this pls..I am getting the same output for the change in the value of D1

declare @D1 datetime = '20120229' --...

Guitar_player (2/16/2015)

---

Hi,

I am not an expert in SQL , but i been trying to get the difference of two dates in years.days format like

1 year 230 days -->...

Nevyn (2/13/2015)

---

Phil Parkin (2/13/2015)

---

Nevyn (2/11/2015)

---

Its a known bug they apparently decided not to fix

Also, the alleged work around is to sort the packages in the dtproj file, so I'm surprised...

Nevyn (2/11/2015)

---

Its a known bug they apparently decided not to fix

Also, the alleged work around is to sort the packages in the dtproj file, so I'm surprised that didn't work...

paul.j.kemna (2/11/2015)

---

Ok, I am thinking this through and it might work. Does it make a difference if the datetime is part of my PK? The key on my table...

Dave Ballantyne (2/12/2015)

---

Use the OUTPUT clause and the $action column https://msdn.microsoft.com/en-us/library/ms177564.aspx you can then aggregate over that.

Note: I have found that it is a real performance hit and only do...

This is a lot of messing about! I'm not very familiar with AS/400 databases, but I have an idea which might at least make things work for you – it...

Right. As this is dragging somewhat, I set up a test to make sure it works. Here is what I did:

1) Create a package containing a single trivial ExecuteSQL task...