We have designed a DTS package in SQL 2000 that moves data
from the source DB2 to the destination Oracle. As each
row successfully inserts into the destination table, a
flag is changed on the source table to indicate it was
processed. Currently we have an ActiveX script task with
code to set the existing global varibles equal various
properties of the transformation task.

In trying an alternative way to pass the varibles, we set
up "Execute a SQL task" to insert a row into a SQL table
passing the global varibles we set values for in a
previous ActiveX task. We get an error message when we
run the package outside of DTS designer, "One Task
Failed", "Task reported failure on execution"

We are stumped as to why the Execute SQL task fails to
even execute.

And the text of the statement is ?
Try enabling logging in the package
What is the structure you are trying to insert into ?
What are the values you are trying to insert ?

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Mary" <Mary_Scheffler (AT) urscorp (DOT) com> wrote