Re: Execute Package Task fails if called from VB
From: Don (chambersdon_at_hotmail.com)
Date: 03/01/05
- Next message: Simon Worth: "Re: Stopping VBScript Loop on Cancel"
- Previous message: James: "multiple transforms to one file"
- In reply to: Wayne Snyder: "Re: Execute Package Task fails if called from VB"
- Messages sorted by: [ date ] [ thread ]
Date: 1 Mar 2005 12:47:06 -0800
The error message is below.
This package works fine if run from enterprise manage but throws the
error when VB.NET executes it. I have selected 'execute on main
package thread' but it still fails.
The package task moves data from SQL Server to Oracle and then kicks of
an Oracle stored procedure using an Execute SQL task. The first step
that of the sub package that moves data from SQL Server to Oracle works
then I get the error.
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Execution was canceled by user. Step Error code:
80040427 Step Error Help File:sqldts80.hlp Step Error Help Context
ID:10100
- Next message: Simon Worth: "Re: Stopping VBScript Loop on Cancel"
- Previous message: James: "multiple transforms to one file"
- In reply to: Wayne Snyder: "Re: Execute Package Task fails if called from VB"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
