How do I write expression for converting Date Format?

Question

I want to convert English Date to French Format by writing in Expression builder in SSIS...

Could anyone look into this and do needful?

Answer 1

If the source for a date value is a string, then it has a string format.

If the destination is of date(time), it has a (binary) value without any format.

You can use plain T-SQL function CONVERT with format parameter 103 = British, see

https://learn.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver16

Answer 2

Hi @Ramana Kopparapu，

It seems that we could not do that from SSIS Expression builder.

You may load data to staging table and then use tsql command to do that.

SET LANGUAGE French
SELECT CONVERT(VARCHAR(12),CAST('2015-01-01' AS DATETIME),107)

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.