Very Computer

by **Daniel Shar** » Fri, 06 Jun 2003 08:01:16

hi guys

i run a job with multiple DTS, but fire error

i use type = Operating System Command (CmdExec)
and my command is
dtsrun /FD:\daniel\AP_ConceptoGasto.dts;
dtsrun /FD:\daniel\AP_GastoClasificacion.dts;
dtsrun /FD:\daniel\AP_GastoConceptoClasificacion.dts;
dtsrun /FD:\daniel\AP_ConceptoGastoGrupo.dts

the Job History show Result Failed

please helpme

daniel

by **Daniel Shar** » Fri, 06 Jun 2003 08:24:33

forget the problem ;)

daniel #

Quote:> hi guys

> i run a job with multiple DTS, but fire error

> i use type = Operating System Command (CmdExec)
> and my command is
> dtsrun /FD:\daniel\AP_ConceptoGasto.dts;
> dtsrun /FD:\daniel\AP_GastoClasificacion.dts;
> dtsrun /FD:\daniel\AP_GastoConceptoClasificacion.dts;
> dtsrun /FD:\daniel\AP_ConceptoGastoGrupo.dts

> the Job History show Result Failed

> please helpme

> daniel

by **Wend** » Fri, 27 Jun 2003 02:07:20

How did you fix it. I am able to run and even execute a
single package but I am not able to schedule that package
to run at a later time. I get the following error
Error = -2147467259 (80004005) Error string: [Via]
[ODBC Pick Driver]WinLink Connect Failure (-103)
Error source: Microsoft OLE DB Provider for ODBC
Drivers Help file: Help context: 0 Error
Detail Records: Error: -2147467259 (80004005);
Provider Error: 1 (1) Error string: [Via][ODBC Pick
Driver]WinLink Connect Failure (-103) Error source:
Microsoft OLE DB Provider for ODBC Drivers

I need help desperately. Any help would be greatly
appreciated.

>-----Original Message-----
>forget the problem ;)

>daniel #

>> hi guys

>> i run a job with multiple DTS, but fire error

>> i use type = Operating System Command (CmdExec)
>> and my command is
>> dtsrun /FD:\daniel\AP_ConceptoGasto.dts;
>> dtsrun /FD:\daniel\AP_GastoClasificacion.dts;
>> dtsrun /FD:\daniel\AP_GastoConceptoClasificacion.dts;
>> dtsrun /FD:\daniel\AP_ConceptoGastoGrupo.dts

>> the Job History show Result Failed

>> please helpme

>> daniel

>.

by **Allan Mitchel** » Fri, 27 Jun 2003 04:00:15

80004005 - would suggest a permissions problem and the fact that it works
manually but not scheduled increases that suggestion. Most times this
problem can be resolved by looking through this article.

http://support.microsoft.com/?kbid=269074

--

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

> How did you fix it. I am able to run and even execute a
> single package but I am not able to schedule that package
> to run at a later time. I get the following error
> Error = -2147467259 (80004005) Error string: [Via]
> [ODBC Pick Driver]WinLink Connect Failure (-103)
> Error source: Microsoft OLE DB Provider for ODBC
> Drivers Help file: Help context: 0 Error
> Detail Records: Error: -2147467259 (80004005);
> Provider Error: 1 (1) Error string: [Via][ODBC Pick
> Driver]WinLink Connect Failure (-103) Error source:
> Microsoft OLE DB Provider for ODBC Drivers

> I need help desperately. Any help would be greatly
> appreciated.
> >-----Original Message-----
> >forget the problem ;)

> >daniel #

> >> hi guys

> >> i run a job with multiple DTS, but fire error

> >> i use type = Operating System Command (CmdExec)
> >> and my command is
> >> dtsrun /FD:\daniel\AP_ConceptoGasto.dts;
> >> dtsrun /FD:\daniel\AP_GastoClasificacion.dts;
> >> dtsrun /FD:\daniel\AP_GastoConceptoClasificacion.dts;
> >> dtsrun /FD:\daniel\AP_ConceptoGastoGrupo.dts

> >> the Job History show Result Failed

> >> please helpme

> >> daniel

> >.

Very Computer

problem with job and multiple DTS

problem with job and multiple DTS

problem with job and multiple DTS

problem with job and multiple DTS

problem with job and multiple DTS