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 a Data Philosopher at Andy Leonard Consulting, an SSIS Trainer, Consultant, and developer; a Business Intelligence Markup Language (Biml) developer and BimlHero; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server Integration Services Design Patterns, and author of Managing Geeks - A Journey of Leading by Doing, and the Stairway to Integration Services.

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 06, 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 Company

Community Awards

Friend of Red Gate

Contact Me


Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement