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...

Can you tell us the full data types of all the columns involved please?

Edit: have a look here. It is likely that you are experiencing rounding errors at a very...

Here's how I would do it.

Add a lookup to your package and use it to determine Insert vs Update.

If it's an Insert, send it directly to the target table.

If it's...

rocky_498 (2/9/2015)

---

Opps I should mention.

I am using so far two transformations ( Derived Column, Data Conversion)

Plus I am using SCD..

That would be next question. If I pick Second Option...

What sort of transformations do you have in mind?

Will you be doing just inserts, or inserts and updates, or inserts, updates and deletes?

Guitar_player (2/9/2015)

---

nope ...but on click of the 'Parameterize' option, we will get the chance of selecting our own property i believe but i just have selected the connectionstring instead of...

Guitar_player (2/9/2015)

---

Let me explain,

We will have project connections in our connection manager , so i right click on them and clicked on "Parameterize" option

and selected the connection string...