THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

SSIS Snack: Package Version

Here's a couple cool SSIS Expressions for creating Package Version strings:

Format: 1.0.0

(DT_STR,4,1252) @[System::VersionMajor] + "." + (DT_STR,4,1252) @[System::VersionMinor] + "." + (DT_STR,4,1252) @[System::VersionBuild]


(DT_STR,4,1252) @[System::VersionMajor] + "." + (DT_STR,4,1252) @[System::VersionMinor] + "." + (DT_STR,4,1252) @[System::VersionBuild] + "." + (DT_STR,4,1252) Year(GetDate()) + (Month(GetDate()) < 10 ? "0" + (DT_STR,2,1252) Month(GetDate()) : (DT_STR,2,1252) Month(GetDate()))  + (Day(GetDate()) < 10 ? "0" + (DT_STR,2,1252) Day(GetDate()) : (DT_STR,2,1252) Day(GetDate())) 


:{> Andy

Published Wednesday, January 6, 2010 8:00 AM by andyleonard
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement