|
Home > Archive > MS SQL Server DTS > January 2006 > DTS package terminates early when called from command line
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DTS package terminates early when called from command line
|
|
|
| My DTS package has, in order:
1. a Dynamic Properties task
2. an Execute SQL task
3. a Transform Data task (aka Data Pump task)
When running this DTS package through DTS Designer, it's successful.
When running this DTS package by calling "dtsrun" from the command line, we
sometimes see it fully complete (log messages below):
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDynamicPr
opertiesTask_1
DTSRun OnFinish: DTSStep_DTSDynamicPr
opertiesTask_1
DTSRun OnStart: DTSStep_DTSExecuteSQ
LTask_1
DTSRun OnFinish: DTSStep_DTSExecuteSQ
LTask_1
DTSRun OnStart: DTSStep_DTSDataPumpT
ask_1
DTSRun OnProgress: DTSStep_DTSDataPumpT
ask_1; 63 Rows have been transformed
or copied.; PercentComplete = 0; ProgressCount = 63
DTSRun OnFinish: DTSStep_DTSDataPumpT
ask_1
DTSRun: Package execution complete.
But at other times, we get partial messages, and then the command prompt
returns:
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDynamicPr
opertiesTask_1
DTSRun OnFinish: DTSStep_DTSDynamicPr
opertiesTask_1
DTSRun OnStart: DTSStep_DTSExecuteSQ
LTask_1
No changes are made to the actual DTS package in between runs. We're
calling "dtsrun" from the same machine (app and db) that has the DTS package,
and that the "ExecuteSQLTask" runs against.
The case where the command prompt returns early seems to happen randomly.
Any insight or help would be great. Thanks.
| |
| zzzzzz 2006-01-31, 11:24 am |
| I'm having a similar problem, does anyone know what is going on?
"alee" wrote:
> My DTS package has, in order:
>
> 1. a Dynamic Properties task
> 2. an Execute SQL task
> 3. a Transform Data task (aka Data Pump task)
>
> When running this DTS package through DTS Designer, it's successful.
>
> When running this DTS package by calling "dtsrun" from the command line, we
> sometimes see it fully complete (log messages below):
>
> DTSRun: Loading...
> DTSRun: Executing...
> DTSRun OnStart: DTSStep_DTSDynamicPr
opertiesTask_1
> DTSRun OnFinish: DTSStep_DTSDynamicPr
opertiesTask_1
> DTSRun OnStart: DTSStep_DTSExecuteSQ
LTask_1
> DTSRun OnFinish: DTSStep_DTSExecuteSQ
LTask_1
> DTSRun OnStart: DTSStep_DTSDataPumpT
ask_1
> DTSRun OnProgress: DTSStep_DTSDataPumpT
ask_1; 63 Rows have been transformed
> or copied.; PercentComplete = 0; ProgressCount = 63
> DTSRun OnFinish: DTSStep_DTSDataPumpT
ask_1
> DTSRun: Package execution complete.
>
> But at other times, we get partial messages, and then the command prompt
> returns:
>
> DTSRun: Loading...
> DTSRun: Executing...
> DTSRun OnStart: DTSStep_DTSDynamicPr
opertiesTask_1
> DTSRun OnFinish: DTSStep_DTSDynamicPr
opertiesTask_1
> DTSRun OnStart: DTSStep_DTSExecuteSQ
LTask_1
>
> No changes are made to the actual DTS package in between runs. We're
> calling "dtsrun" from the same machine (app and db) that has the DTS package,
> and that the "ExecuteSQLTask" runs against.
>
> The case where the command prompt returns early seems to happen randomly.
>
> Any insight or help would be great. Thanks.
>
>
|
|
|
|
|