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

Cralis (4/29/2009)

---

To add to that, I have tried to run my task, and get an error...

Error: 0x0 at Check Vehicle Mappings: No result rowset is associated with the execution of...

Pretty much - you're on the right path! Start running it with some test data and seeing what happens ... the best way to learn.

I would use Expression and Constraint,...