Enumeração DTSPackageType
Identifies the tool that created the package.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (em Microsoft.SqlServer.ManagedDTS.dll)
Sintaxe
'Declaração
Public Enumeration DTSPackageType
'Uso
Dim instance As DTSPackageType
public enum DTSPackageType
public enum class DTSPackageType
type DTSPackageType
public enum DTSPackageType
Membros
Nome do membro | Descrição | |
---|---|---|
Default | Undefined. | |
DTSDesigner | Specifies that the package was created in the designer in SQL Server 2000. | |
DTSDesigner100 | Specifies that the package was created in SSIS Designer in SQL Server 2008 Integration Services (SSIS). | |
DTSWizard | Specifies that the package was created by the SQL Server Import and Export Wizard. | |
SQLDBMaint | Specifies that the DBMaint client created the package. | |
SQLReplication | Specifies that the package was generated to support transformable subscriptions. |
Exemplos
The following code example loads one of the Integration Services package samples, and displays its package type, which is one of the values from this enumeration.
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace Microsoft.SqlServer.SSIS.Samples
{
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\SmoTablesDBCC\SmoTablesDBCC\SmoTablesDBCC.dtsx", null);
// Display the package type.
Console.WriteLine("The package type is: {0}", pkg.PackageType);
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace Microsoft.SqlServer.SSIS.Samples
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\SmoTablesDBCC\SmoTablesDBCC\SmoTablesDBCC.dtsx", Nothing)
' Display the package type.
Console.WriteLine("The package type is: {0}", pkg.PackageType)
End Sub
End Class
End Namespace
Sample Output:
The package type is: DTSDesigner100