This topic has not yet been rated - Rate this topic

Application.SaveToXml Method

Saves the XML definition of a package to a file.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Syntax

C++

JScript

Copy

public void SaveToXml(
	string fileName,
	Package package,
	IDTSEvents events
)

Parameters

fileName: Type: System.String
The name of the file to save.

package: Type: Microsoft.SqlServer.Dts.Runtime.Package
The package object to save.

events: Type: Microsoft.SqlServer.Dts.Runtime.IDTSEvents
An IDTSEvents object.

Remarks

A package file normally has the extension, .dtsx.

If the file name specified in the fileName parameter does not exist, it will be created.

Examples

The following example saves the .dtsx package in XML format with the name myXMLPackage.dtsx.

Copy

static void Main(string[] args)
        {
            // The variable pkg points to the location
            // of the ExecuteProcess package sample 
            // that is installed with the SSIS samples.
            string pkg = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";

            Application app = new Application();
            Package p = app.LoadPackage(pkg, null);
            app.SaveToXml("myXMLPackage.dtsx", p, null);
        }

Reference

Application Class

Microsoft.SqlServer.Dts.Runtime Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)