The following code example saves the sample package named ExecuteProcess.dtsx to the msdb folder, with a new name of myNewPackage. 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 specified in packagePath will be listed.
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);
// Save the package to the SQL Server msdb folder, which is
// also the MSDB folder in the Integration Services service, or as a row in the
//sysssispackages table.
app.SaveToSqlServerAs(p, null, "myNewPackage", "yourserver", null, null);
}
Shared Sub Main(ByVal args() As String)
' The variable pkg points to the location
' of the ExecuteProcess package sample
' that is installed with the SSIS 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 p As Package = app.LoadPackage(pkg,Nothing)
' Save the package to the SQL Server msdb folder, which is
' also the MSDB folder in the Integration Services service, or as a row in the
'sysssispackages table.
app.SaveToSqlServerAs(p, Nothing, "myNewPackage", "yourserver", Nothing, Nothing)
End Sub