The destination table , having check constraints I assume, does the logical checks for you. In the dataflow you can redirect error rows to another table. From there you could...

Firewolf (8/26/2016)

---

MMartin1 (8/23/2016)

---

Hi :

Since we dont have the information that is in your mind, we need a more structure approach so that we can effectively understand your issue without ambiguity....

Eric M Russell (8/26/2016)

---

But you probably know that db_ddbadmin...

I guess things like this happen when there is no effort to learn what the other roles are, like ddl admin.

The word 'on' is broken up by a new line. I dont know if this will or will not be encountered in the situation , so thought I would cover...

Alan.B (8/26/2016)

---

MMartin1 (8/26/2016)

---

DECLARE @text VARCHAR(100);

SET @text= ' set

nocounto

n

...

DECLARE @text VARCHAR(100);

SET @text= ' set

nocounto

n

...

Each of the following could serve your purpose. As others in this post have illustrated, you need to define the precision that will work for you and apply it to...

WHEN cd.Monday = 1 THEN 7

WHEN cd.Tuesday = 1 THEN 6

WHEN cd.Wednesday = 1 THEN 5

WHEN cd.Thursday = 1 THEN 4

WHEN cd.Friday = 1 THEN 3

WHEN cd.Saturday = 1 THEN...

Of course if you had to do this for 100 or more columns, then this is where I introduce Excel to help me quick and dirty.

I just query sys.columns...

Regardless of the method used to prevent a table drop, there should still be regularly practiced drills where you assume a catastrophe of some sort. That means disaster recovery drills...

xsevensinzx (8/25/2016)

---

MMartin1 (8/25/2016)

---

I think overweighting the size portion is not taking into consideration the many benefits of the denormalised model when it comes to reporting, and can gravitate ones thinking...

I think overweighting the size portion is not taking into consideration the many benefits of the denormalised model when it comes to reporting, and can gravitate ones thinking away from...

Phil Parkin (8/24/2016)

---

Which...

Ditto for the other attributes as well. You may very well have limitation on what is possible. You may have it so that you cannot have a certain size in...