This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Hi Expert,
there is null in start date column in ssis and package is failing due to it considering dt_wstr and target it is date in datatype
want to replace it with '1900-01-01'
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Did you have a chance to try the proposed solutions?
Hi @Shambhu Rai ,
SSIS has a much better function: replacenull-ssis-expression
Please try the following expression:
REPLACENULL(Start Date, "1900-01-01")
Or
(DT_DATE)REPLACENULL(Start Date, "1900-01-01")
Hi @Shambhu Rai ,
You may also use
(ISNULL([Start Date]) ? (DT_DBDATE)"1900-01-01" : [Start Date])
Regards，
Zoe
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
ERROR MESSAGE
The ProcessInput method on component "Derived Column" (1) failed with error code 0xC0209029 while processing input "Derived Column Input" (7). The identified component returned an error The ProcessInput method on component "Derived Column" (1) failed with error code 0xC0209029 while processing input "Derived Column Input" (1). The identified component returned an error
I TRIED
ISNULL([Start Date]) ? (DT_DBDATE)"1900-01-01" : (DT_DATE)[Start Date] but not working