kramaswamy (11/8/2011)

---

Why not have a stored procedure, which takes as an input the name of the table?

Then in the procedure you can have a CASE statement, and depending on the...

kramaswamy (11/8/2011)

---

That's definitely more clear, thanks.

You *could* do it with an OLE DB Command, but I don't think it's the most efficient means to what you're trying to accomplish.

A ForEach...

Here you go ....

Operation 1. Select distinct...

Finally got working ... thank you all

This sholud be the one i am trying from 2 days :

LEN(DATEcolumn) == 0 ? NULL(DT_DBDATE) : (DT_DBDATE)DATEcolumn

As my destination is...

quillis131 (10/18/2011)

---

kramaswamy (10/17/2011)

---

If you're using ISNULL in SSIS, then the way you need to use it for your purposes is something like:

ISNULL(column) ? (VALUE_IF_TRUE) : (VALUE_IF_FALSE)

So, for example,

ISNULL(column) ? "1950-01-01"...

kramaswamy (10/19/2011)

---

your source column is SMALLDATETIME, so you can't write the string "NULL" to it.

This expression:

ISNULL(column) ? "NULL" : column

has two data types it is attempting to evaluate to -...

kramaswamy (10/17/2011)

---

If you're using ISNULL in SSIS, then the way you need to use it for your purposes is something like:

ISNULL(column) ? (VALUE_IF_TRUE) : (VALUE_IF_FALSE)

So, for example,

ISNULL(column) ? "1950-01-01" :...

kramaswamy (10/17/2011)

---

Try putting a data viewer right after your derived column transformation, and then view the data exiting that transformation. See if the derived column you've created contains the dummy...

YES....

kramaswamy (10/17/2011)

---

What do you mean by that, exactly? You're saying your source has a NULL value, and in your destination, you get an error saying you can't write a NULL...

kramaswamy (10/17/2011)

---

If you're using ISNULL in SSIS, then the way you need to use it for your purposes is something like:

ISNULL(column) ? (VALUE_IF_TRUE) : (VALUE_IF_FALSE)

So, for example,

ISNULL(column) ? "1950-01-01" :...

Need to extract DATE column to SQL DB (SMALLDATETIME) from DB2. But Source columns has null values ( empty values).... This Date column may also have DATE mentioned for some...

As I can't change it, But I guess there should be a value to fix this .....

Evil Kraig F (8/15/2011)

---

quillis131 (8/15/2011)

---

What makes me Nuts: It was all good in Dev environment, and then deployed it onto Producation ( here it turns out to be crashed) with...

(Dt_DBTimeStamp)Getdate() .... this...