Hi friends
I was processing the data from Excel source to SQL server destination
I'm facing some problem in data in source it was come like "2 mar 2015 2:55:55 PM IST" but i need date time like this 2015-03-02 14:55:55 any one can help me please
Hi friends
I was processing the data from Excel source to SQL server destination
I'm facing some problem in data in source it was come like "2 mar 2015 2:55:55 PM IST" but i need date time like this 2015-03-02 14:55:55 any one can help me please
Hi @KLokesh-0564 ,
We can use Derived Column Transformation in SSIS Data Flow Task to get the result.
Please refer to the following expression and pictures:
(DT_DBTIMESTAMP)((DT_WSTR,10)TOKEN(Date," ",3) + "-" + (DT_WSTR,10)(TOKEN(Date," ",2) == "jan" ? 1 : (TOKEN(Date," ",2) == "feb" ? 2 : (TOKEN(Date," ",2) == "mar" ? 3 : (TOKEN(Date," ",2) == "apr" ? 4 : (TOKEN(Date," ",2) == "may" ? 5 : (TOKEN(Date," ",2) == "jun" ? 6 : (TOKEN(Date," ",2) == "jul" ? 7 : (TOKEN(Date," ",2) == "aug" ? 8 : (TOKEN(Date," ",2) == "sep" ? 9 : (TOKEN(Date," ",2) == "oct" ? 10 : (TOKEN(Date," ",2) == "nov" ? 11 : 12))))))))))) + "-" + (DT_WSTR,10)TOKEN(Date," ",1) + " " + (DT_WSTR,10)TOKEN(Date," ",4) + " " + (DT_WSTR,10)TOKEN(Date," ",5))


Best regards,
Mona
If the answer is helpful, please click "Accept Answer" and upvote it.
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.
Hi Mona thanks for your answer thanks you so much 🥰🥰🥰
Hi @KLokesh-0564 ,
It's my pleasure.
Welcome to contact us if you have any new issue.
Best regards,
Mona
4 people are following this question.
SSIS Scale Out and its services on local group policies
Where do I download SSDT July 2016 Update (ver. 14.0.60629.0) from?
we hope Microsoft can develop databases like mysql
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
SSIS - getting data from Oracle - not working preview and metadata refresh