Lynn Pettis (3/5/2015)

---

Won't handle the typical "yes, but ..." or "no, but ..." answers you get from kids and politicians when asked a simple question that can be answered with...

TomThomson (3/4/2015)

---

There is no problem at all with building a trivalent type to handle the truth values of trivalent logic, and if NULLs are reuired that's fine - something can...

Make sure you've got a sufficiently-sized transaction log and appropriate indexes for this!

Regards

Lempster

This is a SQL Server forum. What has your question got to do with SQL Server?

Yes, I misunderstood what you were saying, sorry. Loading data into a destination that does not exist is clearly not going to work! 😉

That's not correct; it is...

You need to capture the errors when inserting into the OLEDB Destination. I suggest creating an Error table with columns that match your destination table and then connecting the error...

The clue is in the error; you need to create your cluster using a Domain account that has...

Hang on a minute... you need to bear in mind that a Lookup task will only return the first occurrence of...

Forget about the subscription for a moment; does the report work when you run it? If not, what is the exact error? Every report needs to have a Data Source...

The goal of database mirroring is to keep two databases synchronized in near real-time for High Availability/Disaster Recover (HA/DR) purposes and the mechanism to achieve that is as Perry states.

It's...

Phil Parkin (2/10/2015)

---

Right. As this is dragging somewhat, I set up a test to make sure it works. Here is what I did:

1) Create a package containing a single trivial...

For a good grounding in the principles that underpin Data Warehouse design which is agnostic of the particular implementation (Kimball or Inmon), Star Schema - The Complete Reference by Christopher...

Yes. The ones you have are ODBC drivers not OLEDB.

You need to download...