dougludlow/ssis-datestamp

Last active August 29, 2015 14:01

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

Select an option

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

Download ZIP

Datestamp for SSIS Expression

Raw

ssis-datestamp

REPLACE(REPLACE(REPLACE(SUBSTRING((DT_STR, 30, 1252)GETDATE(), 1, 19 ) , "-", ""), " ", ""), ":", "")

dougludlow commented May 8, 2014

Author

This will evaluate to the equivalent of 20140508111202.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment