Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

Application.LoadFromSqlServer Method

Loads a package from SQL Server by specifying the server name, user name, and password.

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
public Package LoadFromSqlServer(
	string packagePath,
	string serverName,
	string serverUserName,
	string serverPassword,
	IDTSEvents events
)

Parameters

packagePath
Type: System.String
The name and path of the package to load.
serverName
Type: System.String
The name of the instance of SQL Server that the package is loaded from.
serverUserName
Type: System.String
The SQL Server login name if you use SQL Server Authentication to log into the server; otherwise, null if you use Windows Authentication.
serverPassword
Type: System.String
The SQL Server login password if you use SQL Server Authentication to log into the server; otherwise, null if you use Windows Authentication.
events
Type: Microsoft.SqlServer.Dts.Runtime.IDTSEvents
An IDTSEvents interface.

Return Value

Type: Microsoft.SqlServer.Dts.Runtime.Package
The package that was loaded.

The following code example loads a sample package, which was previously saved to the File System.

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 ExecuteProcess 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 a name of 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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.