PackageInfo.PackageDataSize Propiedad

Definición

Espacio de nombres:

Microsoft.SqlServer.Dts.Runtime

Ensamblado:

Microsoft.SqlServer.ManagedDTS.dll

Devuelve el tamaño de los datos para el paquete. Esta propiedad es de sólo lectura.

public:
 property int PackageDataSize { int get(); };

public int PackageDataSize { get; }

member this.PackageDataSize : int

Public ReadOnly Property PackageDataSize As Integer

Valor de propiedad

Int32

Entero que contiene el tamaño de los datos 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