You can check if the packet was executed sucessfully or not by checking the result object value.

private

{

void button1_Click(object sender, EventArgs e)DTSExecResult result = new DTSExecResult() ;//Declare and instantiate a new DTS application Microsoft.SqlServer.Dts.Runtime.

Application application = new Microsoft.SqlServer.Dts.Runtime.Application();

//Declare a DTS package and import a saved package file (either by creating from SQL Management Studio on 

//export function, or from Bussines Development (new Integration Services project)

 

export.ProtectionLevel = Package export = application.LoadPackage("E:\\Package.dtsx", null,false); DTSProtectionLevel.DontSaveSensitive; //it's always best to handle possible errors!

try

{

//Declare a DTS result, and execute it

result = export.Execute();

//MessageBox.Show("While exporting the file, the following error ocurred: " + result.ToString());

}

{

}

}

catch (DtsException ex)