Re: How to Schedule a DTS ???`

#1

Have a look at this-

http://support.microsoft.com/default...b;en-us;269074

What does DTSStep_DTSActiveScriptTask_1 do, since that is reporting a failed
result state.

--
Darren Green
http://www.sqldts.com

"Jean-Francois Bouchard" <jeanfrancois_21 (AT) hotmail (DOT) com> wrote

Quote:

I have created a DTS that is exporting data to a text file.

I scheduled it to run every hours, but it's always
failed. SQL agent is defined to connect to sql with the
login SA.. and the job is also setup to run with login SA,
wich have SysAdmin right. HEre is the error reported by
job history:

DTSRun: Loading... DTSRun: Executing... DTSRun
OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnError:
DTSStep_DTSActiveScriptTask_1, Error = -2147220421
8004043B) Error string: The task reported failure on
execution. Error source: Microsoft Data
Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 1100 Error Detail
Records: Error: -2147220421 (8004043B); Provider
Error: 0 (0) Error string: The task reported
failure on execution. Error source: Microsoft Data
Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 1100 DTSRun
OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun:
Package execution complete. Process Exit Code 1. The
step failed.

#2

My DTS goes through 5 step (Here is the first one):

1- Active X Script: I Use an FileSystemObject to look if
the text file is already presend on the hard drive. if
yes, I use the command Main = DTSTaskResult_Failed to quit
the DTS and have a failed status.. (With a workflow on the
OnSucess, it goes to step2) maybe i'm not proceding in
the correct way?

Quote:

-----Original Message-----
Have a look at this-

http://support.microsoft.com/default.aspx?scid=kb;en-
us;269074

What does DTSStep_DTSActiveScriptTask_1 do, since that is
reporting a failed
result state.

--
Darren Green
http://www.sqldts.com

"Jean-Francois Bouchard" <jeanfrancois_21 (AT) hotmail (DOT) com
wrote in message
news:0a7601c3633b$9cb6c5b0$a601280a (AT) phx (DOT) gbl...
I have created a DTS that is exporting data to a text
file.

I scheduled it to run every hours, but it's always
failed. SQL agent is defined to connect to sql with the
login SA.. and the job is also setup to run with login
SA,
wich have SysAdmin right. HEre is the error reported by
job history:

DTSRun: Loading... DTSRun: Executing... DTSRun
OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun
OnError:
DTSStep_DTSActiveScriptTask_1, Error = -2147220421
8004043B) Error string: The task reported failure
on
execution. Error source: Microsoft Data
Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 1100 Error Detail
Records: Error: -2147220421 (8004043B); Provider
Error: 0 (0) Error string: The task reported
failure on execution. Error source: Microsoft Data
Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 1100 DTSRun
OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun:
Package execution complete. Process Exit Code 1. The
step failed.

.

#3

If you're using the FSO, you need to be concerned with 1.)the Domain Account
with which the DTS Job/SQL Agent) is running, and 2.) How you're specifying
the file you're checking (ex:. C:\MyFile.txt or
\\MyServer\MyShare\MyFile.txt)

- Rick
"Jean-Francois Bouchard" <jeanfrancois_21 (AT) hotmail (DOT) com> wrote

Quote:

My DTS goes through 5 step (Here is the first one):

1- Active X Script: I Use an FileSystemObject to look if
the text file is already presend on the hard drive. if
yes, I use the command Main = DTSTaskResult_Failed to quit
the DTS and have a failed status.. (With a workflow on the
OnSucess, it goes to step2) maybe i'm not proceding in
the correct way?

-----Original Message-----
Have a look at this-

http://support.microsoft.com/default.aspx?scid=kb;en-
us;269074

What does DTSStep_DTSActiveScriptTask_1 do, since that is
reporting a failed
result state.

--
Darren Green
http://www.sqldts.com

"Jean-Francois Bouchard" <jeanfrancois_21 (AT) hotmail (DOT) com
wrote in message
news:0a7601c3633b$9cb6c5b0$a601280a (AT) phx (DOT) gbl...
I have created a DTS that is exporting data to a text
file.

I scheduled it to run every hours, but it's always
failed. SQL agent is defined to connect to sql with the
login SA.. and the job is also setup to run with login
SA,
wich have SysAdmin right. HEre is the error reported by
job history:

DTSRun: Loading... DTSRun: Executing... DTSRun
OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun
OnError:
DTSStep_DTSActiveScriptTask_1, Error = -2147220421
8004043B) Error string: The task reported failure
on
execution. Error source: Microsoft Data
Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 1100 Error Detail
Records: Error: -2147220421 (8004043B); Provider
Error: 0 (0) Error string: The task reported
failure on execution. Error source: Microsoft Data
Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 1100 DTSRun
OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun:
Package execution complete. Process Exit Code 1. The
step failed.

.

#4

remember it will be looking for the file on the C drive of the server when
you schedule it.

--

----------------------------
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

"Jean-Francois Bouchard" <Jeanfrancois_21 (AT) hotmail (DOT) com> wrote

Quote:

OK, here is some details:
Some of the code I have put is not compatible with the
sheduler.. This is an ACtiveX Script That Look if a
TextFile exist before going to the next step.

This code is always returning Failure from the
Scheduler. But it's working if I execute the DTS
Manually. Here is the code:

if fso.FileExists("c:\fichier.txt") then
Main= DTSTaskExecResult_Success
else
Main= DTSTaskExecResult_Failure
end if

-----Original Message-----
If you're using the FSO, you need to be concerned with
1.)the Domain Account
with which the DTS Job/SQL Agent) is running, and 2.)
How you're specifying
the file you're checking (ex:. C:\MyFile.txt or
\\MyServer\MyShare\MyFile.txt)

- Rick
"Jean-Francois Bouchard" <jeanfrancois_21 (AT) hotmail (DOT) com
wrote in message
news:01a901c36344$b88621b0$a101280a (AT) phx (DOT) gbl...
My DTS goes through 5 step (Here is the first one):

1- Active X Script: I Use an FileSystemObject to look
if
the text file is already presend on the hard drive. if
yes, I use the command Main = DTSTaskResult_Failed to
quit
the DTS and have a failed status.. (With a workflow on
the
OnSucess, it goes to step2) maybe i'm not proceding in
the correct way?

-----Original Message-----
Have a look at this-

http://support.microsoft.com/default.aspx?scid=kb;en-
us;269074

What does DTSStep_DTSActiveScriptTask_1 do, since
that is
reporting a failed
result state.

--
Darren Green
http://www.sqldts.com

"Jean-Francois Bouchard" <jeanfrancois_21 (AT) hotmail (DOT) com
wrote in message
news:0a7601c3633b$9cb6c5b0$a601280a (AT) phx (DOT) gbl...
I have created a DTS that is exporting data to a
text
file.

I scheduled it to run every hours, but it's always
failed. SQL agent is defined to connect to sql
with the
login SA.. and the job is also setup to run with
login
SA,
wich have SysAdmin right. HEre is the error
reported by
job history:

DTSRun: Loading... DTSRun: Executing... DTSRun
OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun
OnError:
DTSStep_DTSActiveScriptTask_1, Error = -2147220421
8004043B) Error string: The task reported
failure
on
execution. Error source: Microsoft Data
Transformation Services (DTS) Package Help
file:
sqldts80.hlp Help context: 1100 Error
Detail
Records: Error: -2147220421 (8004043B);
Provider
Error: 0 (0) Error string: The task reported
failure on execution. Error source: Microsoft
Data
Transformation Services (DTS) Package Help
file:
sqldts80.hlp Help context: 1100 DTSRun
OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun:
Package execution complete. Process Exit Code 1.
The
step failed.

.

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: How to Schedule a DTS ???`

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: How to Schedule a DTS ???` - 08-15-2003 , 09:53 AM

Re: How to Schedule a DTS ???` - 08-15-2003 , 10:48 AM

Re: How to Schedule a DTS ???` - 08-17-2003 , 10:46 AM

Re: How to Schedule a DTS ???` - 08-18-2003 , 07:38 AM