Even though you have different partition functions you can swap the partition out because the structure is the same and the partition boundary in the source is a subset of...

Gazareth (1/26/2013)

---

Can't agree more opc. Powershell's a bit of a cow to learn but it's so useful I'd recommend it to all DBA's. Great tool to have in your utility...

So what approach would you take? Would it be a script to mask the data post-restore? Or a table that is security-controlled with an overlayed view / proc...

PIVOT is nice but it's really just syntactical-sugar Microsoft added in SQL Server 2005 to implement a classic cross-tab query:

SELECT m.Movie,

MAX(CASE...

It sounds like a sketchy design because you want a proc to behave differently based in some implicit condition, namely who called it. Consider how you would unit test something...

What is the actual SQL operation? A series of inserts, updates or deletes? I single query? You never said.

Thank you for trying to provide a well-formed question. It looks like homework, which is fine, I am happy to help but I need a few things first:

1. DDL to...

Thank you for trying to provide a well-formed question. It looks like homework, which is fine, I am happy to help but I need a few things first:

1. DDL to...

You have some orphaned data that you'll need to cleanup before adding the constraint.

SELECT RIDER_NO

FROM TRIP_DETAILS

WHERE RIDER_NO NOT IN (SELECT RIDER_NO

...

Which version of SSIS? Which Oracle driver?

The Excel Destination will simply append results. It sounds like you want to update other columns in the existing data. For that you would need to combine the two package's...

SQL_Kills (1/25/2013)

---

Hi,

I get the following errors when running an ssis package, but tnot sure why this is, it is failure on a lookup table, any ideas?

Error: 0xC020901E at load all...

Never tried it but it's an XML file so could be edited. What are you trying to do?

If there are no transforms have you thought about setting up a Snapshot Replication Publication/Subscription to send data from SQL Server to Oracle?

If you must do this with SSIS then...

@crbnldy, if you provide some DDL so to create your tables, some DML so we can create some test data and the shape of the expected resultset I am confident...