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

Please confirm that you have tried changing the error row disposition to RD_RedirectRow? The error message strongly suggests not.

Sorry 😀

Please explain in more detail what you are trying to do - it is unclear from your original post - and I will attempt to describe how it might...

OK, I changed my mind - let's do it your way after all, as you do not need the staging table data for other reasons.

Create the variable as I mentioned...

Try here:

http://www.jumpstarttv.com/loading-binary-files-into-sql-server-using-ssis_62.aspx

Registration is free.

Create a variable, say RowCount (int32).

Add a Row Count transformation immediately after your source component and map the row count result to the RowCount variable you just created.

Then use precedence...

What you are trying to do is not straightforward, as you have found.

One way is described here, under Self Modifying Packages in SSIS?:

http://www.sqljunkies.com/weblog/knight_reign/

Is this relevant:

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/65d73a61-e720-4568-bbec-81383158292e/