Hey folks...

I have 7 DTS packages that connect to my remote SQL Server and transfers
data to my local server (back it up).
I've made a job that runs these 7 packages every morning andby fridays
an 8th package that runs a BACKUP DATABASE package...

I also have a bigger package that groups all the 7 in one... Using the
workflow...


But every and each one of them returns this error:

Executed as user: DIGI\Administrador. ...ing... DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart: DTSStep_DTSTransferObjectsTask_1 DTSRun OnProgress:
DTSStep_DTSTransferObjectsTask_1; Scripting objects for Transfer;
PercentComplete = 0; ProgressCount = 0 DTSRun OnError:
DTSStep_DTSTransferObjectsTask_1, Error = -2147221504 (80040000) Error
string: Estrutura OLEVERB inválida Error source: Microsoft Data
Transformation Services (DTS) Package Help file: sqldts80.hlp
Help context: 1100 Error Detail Records: Error: -2147221504
(80040000); Provider Error: 0 (0) Error string: Estrutura OLEVERB
inválida Error source: Microsoft Data Transformation Services (DTS)
Package Help file: sqldts80.hlp Help context: 1100
Error: -2147221504 (80040000); Provider Error: 0 (0) Error string:
Estrutura OLEVERB inválida Error source: Microsoft Data Transf.
The step failed.



The Job is returning theses error, if I execute the package my self, it goes
way perfectly...

the jobs are scheduled starting at 7h50, every day, and the next is started
10' after, to avoid overlapping.



tks,
christiano.

On Jul 15, 2:10 pm, "Christiano" <cdo... (AT) digiexpress (DOT) com.br> wrote:
Hi Cristiano,
http://thedotnet.com/nntp/547835/showpost.aspx
Take a look!
Bye,
M.

On Jul 15, 2:10 pm, "Christiano" <cdo... (AT) digiexpress (DOT) com.br> wrote:
Hi Cristiano,
http://thedotnet.com/nntp/547835/showpost.aspx
Take a look!
Bye,
M.

On Jul 15, 2:10 pm, "Christiano" <cdo... (AT) digiexpress (DOT) com.br> wrote:
Hi Cristiano,
http://thedotnet.com/nntp/547835/showpost.aspx
Take a look!
Bye,
M.

On Jul 15, 2:10 pm, "Christiano" <cdo... (AT) digiexpress (DOT) com.br> wrote:
Hi Cristiano,
http://thedotnet.com/nntp/547835/showpost.aspx
Take a look!
Bye,
M.

On Jul 15, 2:10 pm, "Christiano" <cdo... (AT) digiexpress (DOT) com.br> wrote:
Hi Cristiano,
http://thedotnet.com/nntp/547835/showpost.aspx
Take a look!
Bye,
M.

On Jul 15, 2:10 pm, "Christiano" <cdo... (AT) digiexpress (DOT) com.br> wrote:
Hi Cristiano,
http://thedotnet.com/nntp/547835/showpost.aspx
Take a look!
Bye,
M.

On Jul 15, 2:10 pm, "Christiano" <cdo... (AT) digiexpress (DOT) com.br> wrote:
Hi Cristiano,
http://thedotnet.com/nntp/547835/showpost.aspx
Take a look!
Bye,
M.

On Jul 15, 2:10 pm, "Christiano" <cdo... (AT) digiexpress (DOT) com.br> wrote:
Hi Cristiano,
http://thedotnet.com/nntp/547835/showpost.aspx
Take a look!
Bye,
M.