belenaj/SSIS.GenerateDatekeyInt.md

Last active November 22, 2017 13:07

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/belenaj/9e22d05bcf202cf79374ebdbfe0ff809.js"></script>
Save belenaj/9e22d05bcf202cf79374ebdbfe0ff809 to your computer and use it in GitHub Desktop.

Download ZIP

SSIS | Generate Datekey (int) from Date field #SSIS #date #YYYYMMDD

Raw

SSIS.GenerateDatekeyInt.md

SSIS | Generate Datekey (int) from Date field

This expression will extract the date from the field in format YYYYMMDD and it will be converted to integer

i.e. '2017-01-03 13:18:13.667' --> 20170103 (int) Just replace for your field name

(DT_I4)((DT_WSTR,4)(DATEPART("yyyy", <datetime>)) + 
RIGHT("0" + (DT_WSTR,2)DATEPART("mm", <datetime>), 2) + 
RIGHT("0" + (DT_WSTR,2)DATEPART("dd", <datetime>), 2))