Hi,

I finally figured it out.

Don't ask me why but apparently you can only use the "DTS" stuff with in a script TASK not with in a script component.

I used the...

I apologize for not getting back to you. I tried your suggestion and I am getting an error message saying connectionmanager is not defined.

Any ideas.

Thanks.

Peter

Thanks for your response.

I am not some one who looks to this forum for every bit of doubt I have. Unfortunately, the book I have for reference didn't talk much...

Thank you very much. It worked like a charm.

Peter

This example shows how to check for valid date and replace default date for invalid date.

(DT_BOOL)(DT_DATE)IssueDate_C ? IssueDate_C : "01/01/1900"

I guess, I didn't read your initial post correctly. If you want null when the date value is '0' use NULL(DT_DBDATE).

Peter

If you want just the date then you should use DT_DBDATE not DT_DBTIMESTAMP and also don't forget to change the data type.

I am assuming your output is a table. If...

If you look at the code attempted by Murali, he is trying to check for null and his description mentioned source file so depending on a flat file or table...

What is your source and destination, ex. file or table?

Peter

I am still playing around and figuring out what can be done in SSIS. It is simple if you want to insert all the rows from a table into a...

That is kind of the easiest route but I just wanted to know if sql 2005 had any other way that can accomplish the same in a more efficient way.

Thanks.

Peter...

I am assuming you are using expression column to change the data to datetime format. As part of that, check for null or valid date and move a default value...

Thanks for the quick response. I will give that a try.

we do similar processing using stored proc but interested to see if there is a way to do this in SSIS.

Thanks.

Peter Kennedy