I've got a table containing Dates in YYYY-MM-DD which I need to change to YYYYMMDD in SSIS.
I've made some progress after watching this video from Steve Fox.
I'm using SSIS & this all works OK until I want to create a Derived Column on a Date field.
In the video, some expressions are created to creaate the parts of the Date format such as one for 'YY', one for MM etc. They are then Concatenated and a Data Conversion Modules changes the data type to Date.
I found that using RIGHT won't work on dates, so my workaround is to use the Data Conversion Module to change the Date Data Type to String & then try the Derived Column to apply those String functions.
The problem is that no String format I want to apply to this Date field will allow me to then use in the Derived Column transformation?
Can anyone help here? I know the syntax for the Derived Column is correct because it works on non Date fields.