tushu373 |
Newbie |
Tushar |
boston |
|
|
None Specified |
|
Thursday, July 31, 2014 |
Thursday, February 26, 2015 4:01:12 PM |
5 [0.03% of all post / 0.00 posts per day] |
|
Hi Did you fine solution for this?
Altova really needs to work on this
thanks
|
Did you find the solution?
I am having same issue thanks
|
thanks VLAD, i used empty string function and the filter node and then parse date as you suggested and it worked.
thanks a lot
|
Hi All
I am mapping a flat file to MSSQL database. Source file has column with YYYYMMDD format, and I am mapping it with DATE column in MSSQL server. i am using parse-date function, with [Y,4-4][M,2-2][D,2-2] as format. It works fine, until the source file have empty or null in it. and give error "Month 0 out of range".
My question is , if the source column has null values then it should insert null into database. How to handle if the column has null values?
thanks Tushar
|
What is the solution???
Thanks in advance
|
|