SSIS Expression Syntax
Hi experts,
I am new to SSIS 2008 and I wanted to add a new derived column to my table. What I really want is a way to write a SQL expression to do the same thing as this TSQL statement:
, ISNULL(DateTime1, Datetime2) AS Arrived
how do I do the same thing as above as an SQL expression and have it create a new Column for me called Arrived?
I am new to SSIS 2008 and I wanted to add a new derived column to my table. What I really want is a way to write a SQL expression to do the same thing as this TSQL statement:
, ISNULL(DateTime1, Datetime2) AS Arrived
how do I do the same thing as above as an SQL expression and have it create a new Column for me called Arrived?
ASKER
Ok I'll give it a try
ASKER
Well, I think it will work. I have an ole db source, on success connected to a derived column. The column exists in the Source (As I added it as a datetime column). There are only around 200,000 rows from the source but It is reading 4X that. Any ideas what I might have done wrong? I can submit as a separate question if that would be better.
do I need to run the Derived column through a data conversion step first?
Data-Flow-ETL.docx
do I need to run the Derived column through a data conversion step first?
Data-Flow-ETL.docx
can u post the sql in the ole db source?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ISNULL(DateTime1) ? DateTime2 : DateTime1