Application.SaveToSqlServer Method (Package, IDTSEvents, String, String, String)


Saves a package to an instance of SQL Server.

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

public void SaveToSqlServer(
	Package package,
	IDTSEvents events,
	string serverName,
	string serverUserName,
	string serverPassword


Type: Microsoft.SqlServer.Dts.Runtime.Package

The package to save.

Type: Microsoft.SqlServer.Dts.Runtime.IDTSEvents

The IDTSEvents object.

Type: System.String

The name of the instance of SQL Server to save the package to.

Type: System.String

The user name used to log on to the server.

Type: System.String

The password for the user account.

The following code example saves the sample package to SQL Server. To verify that the package was saved, run the following Transact-SQL query against the msdb database. The query returns all packages stored in the msdb system table.

select * from sysssispackages

Or, connect to the Integration Services service, expand Stored Packages, and then expand MSDB. The package with the name UsingExecuteProcess will be listed.

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;

namespace LoadFromSQLServerTest
    class Program
        static void Main(string[] args)
            // The variable, pkg, points to the location
            // of the UsingExecuteProcess sample installed with
            // the SSIS package 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 loadedPkg = app.LoadPackage(pkg, null);

            // Save the package to SQL Server.
            app.SaveToSqlServer(loadedPkg, null, "yourserver", null, null);

            // The package can now be viewed in the 
            // Microsoft SQL Server Management Studio, in the 
            // Integration Services / Stored Packages / MSDB folder,
            // with the name UsingExecuteProcess.
            Package pkgIn = new Package();
            pkgIn = app.LoadFromSqlServer("\\UsingExecuteProcess", "yourserver", null, null, null);
            DateTime pkgCreation = pkgIn.CreationDate;
            Console.WriteLine("Creation Date = {0}", pkgCreation);

Sample Output:

Creation Date = 5/5/2003 5:46:00 PM

Return to top