Netprogram calls ssis's dtspackage .doc

Vb.net
1. ReferenceMicrosoft. SqlServer. ManagedDTS component
2. Use Imports Microsoft. SqlServer. Dts. Runtime to name an empty space for the duration.
3. generation:

Code
Public Function ExecutePackage () As Integer

Dim pkg As String = "E: \ project \ DropShipment \ Code \ TXTImport \ Package. dtsx"

Dim app As Application = New Application ()

Dim p As Package = app. LoadPackage (pkg, Nothing)

'P. InteractiveMode = True

Dim vir As Variables = p. Variables

'Vir ("User: PackageID"). Value = 4

If p. Execute (Nothing, vir, Nothing) = DTSExecResult. Success Then

Return 0

Else

Return 1

End If

 

End Function
C # Code
Public int ExecutePackage ()
{
String pkg = @ "E: \ project \ DropShipment \ Code \ TXTImport \ Package. dtsx ";
Application app = new Application ();
Package p = app. LoadPackage (pkg, null );
Variables vir = p. Variables;

// P. Execute (null, vir, null)

If (p. Execute () = DTSExecResult. Success)
{
Label1.Text = "success ";
Return 0;
}
Else
{
Label1.Text = "error ";
Return 1;
}
}