I am not sure how to debug my code.

I am Executing adts package within .cs code in a .Net Web Application.

The code compiles and runs with no errors.
I rum package.Execute();

My dts package has six steps. The first one gets executed. Then a logout
occurs.

What am I doing wrong here?

If there a package timeout?
Does Execute() expect the package to have just one step?

If you want to trace DTS error, you must use this code!!
===code start===
private string[] tracePackageError(DTS.Package2 oPackage)
{
int ErrorCode = 0;
string ErrorSource = "";
string ErrorDescription = "";
string ErrorHelpFile = "";
int ErrorHelpContext = 0;
string ErrorIDofInterfaceWithError = "";

for(int i=1;i<oPackage.Steps.Count+1;i++)
{
if(oPackage.Steps.Item(i).ExecutionResult ==
DTS.DTSStepExecResult.DTSStepExecResult_Failure)
{
oPackage.Steps.Item(i).GetExecutionErrorInfo(out ErrorCode, out
ErrorSource, out ErrorDescription, out ErrorHelpFile, out ErrorHelpContext,
out ErrorIDofInterfaceWithError);
}
}
string[] tmpReturn = new string[]{oPackage.Name, ErrorCode.ToString(),
ErrorSource, ErrorDescription, ErrorHelpFile, ErrorHelpContext.ToString(),
ErrorIDofInterfaceWithError};
return tmpReturn;
}
===code end===

"jmv" wrote:

You can use other code, such as event handlers which can be a better
solution depending on the application-

319985 - HOW TO: Handle Data Transformation Services Package Events in
Visual C# .NET
(http://support.microsoft.com/default...9985&Product=s
ql2k)


In message <BBCF5E62-5B79-4C1F-8D5F-EB50679ABB1F (AT) microsoft (DOT) com>,
Kevinlife <Kevinlife (AT) discussions (DOT) microsoft.com> writes
<snip>


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org