DTSPackageInfoFlags Enum

Definition

Namespace:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

Describes whether a package is a folder or package. It is used for setting a valid value in the Flags property.

C#

public enum DTSPackageInfoFlags

Inheritance

Enum

DTSPackageInfoFlags

Fields

Name	Value	Description
Folder	0	This is a folder.
Package	1	This is a package.

Examples

The following code example loads a sample package and displays some package properties, including the Flags property, which returns a value from this enumeration.

C#

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("Flags:               {0}", pinfo.Flags);  
                Console.WriteLine("Folder:              {0}", pinfo.Folder);  
                Console.WriteLine("Name:                {0}", pinfo.Name);  
            }  
         }  
    }  
}  

Sample Output:

Package Information

CreationDate: 3/24/2008 5:21:51 PM

Flags: Package

Folder: File System

Name: myp1Package

Applies to