ssis Convert datatype from Integer in YYYYMMDD format to Date Using Built in conversion
Example
Using Derived column we can prepare the input. We will provide yyyy-MM-dd to the final conversion:
- Year: (DT_STR,4,1252)(DataDate / 10000)
- Month: (DT_STR,2,1252)(DataDate / 100 % 100)
- Day: (DT_STR,2,1252)(DataDate % 100)
All together: (DT_DBDATE)((DT_STR,4,1252)(DataDate / 10000) + "-" + (DT_STR,2,1252)(DataDate / 100 % 100) + "-" + (DT_STR,2,1252)(DataDate % 100))
This is a faster solution than a scripting components, but less readable.
