Solved

SSIS Expression Syntax

Posted on 2010-08-30
5
469 Views
Last Modified: 2013-11-10
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?
0
Comment
Question by:Aaron Goodwin
  • 2
  • 2
5 Comments
 
LVL 30

Expert Comment

by:Reza Rad
ID: 33561704
try this expression:

ISNULL(DateTime1) ? DateTime2 : DateTime1
0
 

Author Comment

by:Aaron Goodwin
ID: 33561917
Ok I'll give it a try
0
 

Author Comment

by:Aaron Goodwin
ID: 33566102
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
0
 
LVL 16

Expert Comment

by:vdr1620
ID: 33567252
can u post the sql in the ole db source?
0
 
LVL 30

Accepted Solution

by:
Reza Rad earned 250 total points
ID: 33567986
actually problem is in your source query,
post your query exactly here,
and also post new question for this, because It differ from current question area
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
query execution hang 5 28
TSQL - How to declare table name 26 28
Oracle Query - Return results based on minimum value 8 29
T-SQL Default value in Select? 5 23
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

805 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question