THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help

Home

Blogs

Forums

Downloads

Opml

Andy Leonard

Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server MVP Deep Dives. His background includes web application architecture and development, VB, and ASP. Andy loves the SQL Server Community!

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]

Format: 1.0.0.20100106

(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()))

Enjoy!

:{> Andy

Published Wednesday, January 06, 2010 8:00 AM by andyleonard