Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Gets the build version of the package.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
Syntax
'Declaration
Public Property VersionBuild As Integer
Get
Set
'Usage
Dim instance As Package
Dim value As Integer
value = instance.VersionBuild
instance.VersionBuild = value
public int VersionBuild { get; set; }
public:
property int VersionBuild {
int get ();
void set (int value);
}
member VersionBuild : int with get, set
function get VersionBuild () : int
function set VersionBuild (value : int)
Property Value
Type: System.Int32
The build version of the package.
Examples
The following example retrieves version information from a package installed with the SSIS samples.
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace Package_API
{
class Program
{
static void Main(string[] args)
{
Application app = new Application();
Package pkg = new Package();
pkg = app.LoadPackage(@"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx", null);
// Review several properties on the sample package using different techniques.
int pkgBuild = pkg.VersionBuild;
int pkgVerMajor = pkg.VersionMajor;
int pkgVerMinor = pkg.VersionMinor;
String entireVersion = pkgVerMajor.ToString() + "." + pkgVerMinor.ToString();
Console.WriteLine("Build number for package {0}", pkgBuild);
Console.WriteLine("any comments? {0}", pkg.VersionComments);
Console.WriteLine("What is the GUID? {0}", pkg.VersionGUID);
Console.WriteLine("Version numbers {0}", entireVersion);
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace Package_API
Class Program
Shared Sub Main(ByVal args() As String)
Dim app As Application = New Application()
Dim pkg As Package = New Package()
pkg = app.LoadPackage("C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx", Nothing)
' Review several properties on the sample package using different techniques.
Dim pkgBuild As Integer = pkg.VersionBuild
Dim pkgVerMajor As Integer = pkg.VersionMajor
Dim pkgVerMinor As Integer = pkg.VersionMinor
Dim entireVersion As String = pkgVerMajor.ToString() + "." + pkgVerMinor.ToString()
Console.WriteLine("Build number for package {0}", pkgBuild)
Console.WriteLine("any comments? {0}", pkg.VersionComments)
Console.WriteLine("What is the GUID? {0}", pkg.VersionGUID)
Console.WriteLine("Version numbers {0}", entireVersion)
End Sub
End Class
End Namespace
Sample Output:
Build number for package 143
any comments?
What is the GUID? {0FF64FA0-2FB7-49C1-BB20-6439EDD1EE44}
Version numbers 1.0