PackageInfo.VersionBuild Propiedad
Definición
Importante
Parte de la información hace referencia a la versión preliminar del producto, que puede haberse modificado sustancialmente antes de lanzar la versión definitiva. Microsoft no otorga ninguna garantía, explícita o implícita, con respecto a la información proporcionada aquí.
Devuelve el número de versión de la compilación del paquete. Esta propiedad es de sólo lectura.
public:
property int VersionBuild { int get(); };
public int VersionBuild { get; }
member this.VersionBuild : int
Public ReadOnly Property VersionBuild As Integer
Valor de propiedad
Entero que contiene la versión de compilación del paquete.
Ejemplos
En el ejemplo de código siguiente se carga un paquete de ejemplo, se guarda el paquete en el servicio y, a continuación, se recuperan los paquetes y se recorren en iteración las propiedades.
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace PackageInfoTest
{
class Program
{
static void Main(string[] args)
{
// The pkg variable points to a package
// installed with the SSIS samples.
string pkg = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx";
Application app = new Application();
Package p1 = app.LoadPackage(pkg, null);
p1.Description = "CalculatedColumns package";
app.SaveToDtsServer(p1, null, @"File System\myp1Package", "YOURSERVER");
PackageInfos pInfos = app.GetDtsServerPackageInfos(@"File System", "YOURSERVER");
foreach (PackageInfo pinfo in pInfos)
{
Console.WriteLine("Package Information");
Console.WriteLine("CreationDate: {0}", pinfo.CreationDate);
Console.WriteLine("Description: {0}", pinfo.Description);
Console.WriteLine("Flags: {0}", pinfo.Flags);
Console.WriteLine("Folder: {0}", pinfo.Folder);
Console.WriteLine("Name: {0}", pinfo.Name);
Console.WriteLine("PackageDataSize: {0}", pinfo.PackageDataSize);
Console.WriteLine("PackageGuid: {0}", pinfo.PackageGuid);
Console.WriteLine("VersionBuild: {0}", pinfo.VersionBuild);
Console.WriteLine("VersionComments {0}", pinfo.VersionComments);
Console.WriteLine("VersionGUID {0}", pinfo.VersionGUID);
Console.WriteLine("VersionMajor {0}", pinfo.VersionMajor);
Console.WriteLine("VersionMinor {0}", pinfo.VersionMinor);
Console.WriteLine();
}
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace PackageInfoTest
Class Program
Shared Sub Main(ByVal args() As String)
' The pkg variable points to a package
' installed with the SSIS samples.
Dim pkg As String = "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx"
Dim app As Application = New Application()
Dim p1 As Package = app.LoadPackage(pkg,Nothing)
p1.Description = "CalculatedColumns package"
app.SaveToDtsServer(p1, Nothing, "File System\myp1Package", "YOURSERVER")
Dim pInfos As PackageInfos = app.GetDtsServerPackageInfos("File System","YOURSERVER")
Dim pinfo As PackageInfo
For Each pinfo In pInfos
Console.WriteLine("Package Information")
Console.WriteLine("CreationDate: {0}", pinfo.CreationDate)
Console.WriteLine("Description: {0}", pinfo.Description)
Console.WriteLine("Flags: {0}", pinfo.Flags)
Console.WriteLine("Folder: {0}", pinfo.Folder)
Console.WriteLine("Name: {0}", pinfo.Name)
Console.WriteLine("PackageDataSize: {0}", pinfo.PackageDataSize)
Console.WriteLine("PackageGuid: {0}", pinfo.PackageGuid)
Console.WriteLine("VersionBuild: {0}", pinfo.VersionBuild)
Console.WriteLine("VersionComments {0}", pinfo.VersionComments)
Console.WriteLine("VersionGUID {0}", pinfo.VersionGUID)
Console.WriteLine("VersionMajor {0}", pinfo.VersionMajor)
Console.WriteLine("VersionMinor {0}", pinfo.VersionMinor)
Console.WriteLine()
Next
End Sub
End Class
End Namespace
Salida del ejemplo:
Package Information
CreationDate: 3/24/2008 5:21:51 PM
Description:
Flags: Package
Folder: File System
Name: myp1Package
PackageDataSize: 0
PackageGuid:
VersionBuild: 0
VersionComments
VersionGUID
VersionMajor 0
VersionMinor 0