Phil Parkin (1/12/2016)

---

I just read through the link you suggested. It suggests that the parallel loading of a table will work if that table is a heap. Otherwise it suggests...

Ahh Thanks Lynn!! I just hyperlinked it.

JustMarie (1/11/2016)

---

To address the situation of gap fill or other re-run situations I use a parameter table.

One package to populate the parameters.

One package to pick up the parameters and perform...

Eric M Russell (1/11/2016)

---

You probably already know this, and you didn't specifically mention SCD or if this is a MERGE versus straight INSERT into Destination, but avoid using the SSIS...

Right Phil... I think Eric meant to actually implement the physical column on the source tables. Oracle does have a...

Phil Parkin (1/11/2016)

---

...that would be the most efficient, but the only problem is that if there was an issue with a load that day where it failed, manual intervention would...

The load times vary depending on the table being loaded. As...

Phil Parkin (1/11/2016)

---

Regarding the incremental load, have you considered using a pattern like this?

- Query target table for MaxDate = max(datecreated,datemodified)

- Select from source table where date >= MaxDate

This would...

Thanks a bunch Ed. I'll give that a try. That makes sense to me.

Letron

Hmmm... No I'm not including the schema when passing the table name. Could that be the issue?

How did you determine whether the permissions persisted after the rename? Was...

Thanks for working with me on this guys. Below is the code for the usp_RenameTable stored proc.

CREATE PROCEDURE [dbo].[usp_RenameTable]

-- Add the parameters for the stored procedure here

@t1 nvarchar(50) =...

Hey Ed,

Yes the procedure is using the sp_rename proc. Also both tables are in the dbo schema.

Letron

I appreciate anything you can do Lynn. I'll do some testing on my side as well.

Thanks again!

Letron

Yeah I did say that ... :Whistling:

Actually the real table is not. That's why we are doing the rename. Also both tables are partitioned with the same scheme...

Yes I've thought about ALTER SWITCH but if I'm not mistaken, one of the requirements for ALTER SWITCH is that the target table has to be empty.