Datetime data from Excel to SQL Server 2005 by SSIS


A derived column to convert datetime data from Excel to DT_DBTimeStamp is used. Also all NULL values should be taken care too.
Expression should like this in the derived column:
 
(ISNULL(Sampling_Date) ? NULL(DT_DBTIMESTAMP) : (DT_DBTIMESTAMP)Sampling_Date)
Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s