when I am trying data retrieving from one source to other (as400 to sql server) I have tradeentrydt is blank from row4 below in as400 and in visual studio 2005 SSIS it is taking default date as 2001-01-01 00:00:00 000 I don't know where it is asigned

I want to display null value as no date is available in as400. We are doing same in DTS 2000 it is good as trying to migration to  SSIS it's giving strange error

we have below code in dts

if (IsDate(DTSSource("TRADEENTRYDT") )) then
  DTSDestination("TRADEENTRYDT") = DTSSource("TRADEENTRYDT")
 else
  DTSDestination("TRADEENTRYDT") = NULL
 end if

TradeEntryDt
2015-03-19 00:00:00.000
2015-03-19 00:00:00.000
2015-03-19 00:00:00.000
2001-01-01 00:00:00.000
2001-01-01 00:00:00.000
2001-01-01 00:00:00.000
2001-01-01 00:00:00.000 

trying to achieve same in

DataFlow->Modify Columns -> Derived Column Transformation Editor

I tried in google to find solution to build expression same as above it's not working.

If you could provide any solution or material or link I could refer how to get result as above.

Thanks for your help

• Moved by Tina-ShiMicrosoft contingent staff 18 minutes ago the issue is related to this SSIS

If I add new Script Component with below code it is working for null values

If Row.TRADEENTRYDT.ToString() = "0001-01-01" Then
            Row.TRADEENTRYDT = Nothing
        End If

but I have 10 columns If I do same code above for 10 columns it's taking long time 

what is the better approach to follow  

Thanks

Hi vinod,

Thank you for posting in MSDN forum.

Since this case is related to the SSIS, so we will move this case to this SSIS forum:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlintegrationservices , you will get better support.

Best Regards,