Application.SaveToSqlServer Method
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 )
Parameters
- package
- Type: Microsoft.SqlServer.Dts.Runtime.Package
The package to save.
- events
- Type: Microsoft.SqlServer.Dts.Runtime.IDTSEvents
The IDTSEvents object.
- serverName
- Type: System.String
The name of the instance of SQL Server to save the package to.
- serverUserName
- Type: System.String
The user name used to log on to the server.
- serverPassword
- Type: System.String
The password for the user account.
The following code example saves the sample package under the File System. 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 DTSPackage1 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