Change your data source from 'table' to SQL command.

Select fields from your table and (critically) add a Row_Number() column partitioned on the fields you are using to identify duplicates. So...

You have provided neither

a) sample data, nor

b) an example of what you want to print

yet you are asking for sample code. Leaving aside paranormal abilities, just how do you expect...

When you say the second value, you mean the one which is zero in your sample data? Zero is different from null and needs to be handled differently.

If the value...

Have a look here for an example of how it can be done.

http://blogs.conchango.com/jamiethomson/archive/2006/07/11/4209.aspx

GSquared (5/1/2009)

One way to do that would be something like this:

;with Dupes as

(select row_number() over (partition by facilityid, measureid, order by date desc) as Row,

facilityid,

measureid

from dbo.MyHoldingTable)

delete from Dupes

where Row >...

So the records coming out of the OLEDB source are in the correct order, yet they are written in some other order?

Can you confirm that by adding a Data Viewer...

What is the format of the dates in the source file? Please post an example.

Well done!

Wow, felt like I was downloading a movie as I was waiting for that huge screen-shot to appear 🙂

There is a very strong suggestion that there is a problem with...

One way of making this work is to have a template spreadsheet somewhere, which contains no data, but only the column headings/sheet names. Then your process would be:

a) Delete orig...

Sounds correct, except (hopefully) the rows that you are removing are 'matching', not 'duplicate'.

The 'Upsert' idea, though slightly more complicated, should perform better, as it requires much less disk activity....

What does the package do?

Can you paste the detailed error message?

Is there a 'Date Last Updated' field on the Oracle data? If not, can you add one?

Initially, you will have to load all the data, but after that, just select...

Easy. Create a new 'parent' package.

In that, string together your already developed packages as a series of Execute Package tasks.

Running the parent package will then execute all of your 'child'...

So you are trying to add a copy of an existing column to an existing table?

This sounds like a one-off design task - why are you thinking of using SSIS...