Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
LoadFromSqlServer Method

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 Function LoadFromSqlServer ( _
	packagePath As String, _
	serverName As String, _
	serverUserName As String, _
	serverPassword As String, _
	events As IDTSEvents _
) As Package
Dim instance As Application
Dim packagePath As String
Dim serverName As String
Dim serverUserName As String
Dim serverPassword As String
Dim events As IDTSEvents
Dim returnValue As Package

returnValue = instance.LoadFromSqlServer(packagePath, _
	serverName, serverUserName, serverPassword, _


Type: System.String
The name and path of the package to load.
Type: System.String
The name of the instance of SQL Server that the package is loaded from.
Type: System.String
The SQL Server login name if you use SQL Server Authentication to log into the server; otherwise, Nothing if you use Windows Authentication.
Type: System.String
The SQL Server login password if you use SQL Server Authentication to log into the server; otherwise, Nothing if you use Windows Authentication.
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.

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace LoadFromSQLServerTest
    Class Program
        Shared  Sub Main(ByVal args() As String)
            ' The variable, pkg, points to the location
            ' of the ExecuteProcess sample installed with
            ' the SSIS package samples.
            Dim pkg As String =  "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx" 
            Dim app As Application =  New Application() 
            Dim loadedPkg As Package =  app.LoadPackage(pkg,Nothing) 
            ' Save the package to SQL Server.
            app.SaveToSqlServer(loadedPkg, Nothing, "yourserver", Nothing, Nothing)
            ' 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.
            Dim pkgIn As Package = New Package() 
            pkgIn = app.LoadFromSqlServer("\\UsingExecuteProcess", "yourserver", Nothing, Nothing, Nothing)
            Dim pkgCreation As DateTime =  pkgIn.CreationDate 
            Console.WriteLine("Creation Date = {0}", pkgCreation)
        End Sub
    End Class
End Namespace

Sample Output:

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

Community Additions

© 2015 Microsoft