| Author |
Cannot open a log file of specified name
|
|
| Cismail via SQLMonster.com 2006-03-28, 8:27 pm |
| Hello,
I have a DTS package called 'MASTER' which performs 8 execute DTS package
tasks.
There are no workflows defined for 'MASTER'. The 'MASTER' DTS as well as 7 of
the 8 packages it
executes all have the same error log file name specified in the logging tab
of package properties.
'MASTER' is scheduled to run every 10 minutes and for the most part works
fine, except every so often
I get this 'Cannot open a log file of specified name' error.
Below is the error log text file generated:
The execution of the following DTS Package succeeded:
Package Name: CTR340 UpLoad VisitSequence
Package Description: TEST
Package ID: {60CC92FA-72B5-4B4A-BC64-977DDD046307}
Package Version: {F1C7BFE3-0753-4FBB-8EE1-D991B5F8CAC5}
Package Execution Lineage: {FBFB494D-CBD4-4AC0-A9FD-956F90495C40}
Executed On: TESTSERVER
Executed By: usertest
Execution Started: 2006-03-28 11:07:36 AM
Execution Completed: 2006-03-28 11:07:41 AM
Total Execution Time: 4.828 seconds
Package Steps execution information:
Step 'DTSStep_DTSDataPump
Task_5' succeeded
Step Execution Started: 2006-03-28 11:07:38 AM
Step Execution Completed: 2006-03-28 11:07:41 AM
Total Step Execution Time: 2.375 seconds
Progress count in Step: 0
Step 'DTSStep_DTSDataDriv
enQueryTask_1' succeeded
Step Execution Started: 2006-03-28 11:07:41 AM
Step Execution Completed: 2006-03-28 11:07:41 AM
Total Step Execution Time: 0.032 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteS
QLTask_1' succeeded
Step Execution Started: 2006-03-28 11:07:41 AM
Step Execution Completed: 2006-03-28 11:07:41 AM
Total Step Execution Time: 0 seconds
Progress count in Step: 0
********************
********************
********************
********************
********************
The execution of the following DTS Package succeeded:
Package Name: CTR340 UpLoad BalanceValue
Package Description: TEST
Package ID: {18EE3EBC-571A-4D98-855C-E17648BEDAA1}
Package Version: {FD223267-DB22-4810-8E75-97E1E73772DE}
Package Execution Lineage: {A29B1E8A-C442-4DF9-A2A9-36D4ED08FC0B}
Executed On: TESTSERVER
Executed By: usertest
Execution Started: 2006-03-28 11:07:38 AM
Execution Completed: 2006-03-28 11:07:43 AM
Total Execution Time: 4.594 seconds
Package Steps execution information:
Step 'DTSStep_DTSDataPump
Task_4' succeeded
Step Execution Started: 2006-03-28 11:07:41 AM
Step Execution Completed: 2006-03-28 11:07:43 AM
Total Step Execution Time: 2.516 seconds
Progress count in Step: 0
Step 'DTSStep_DTSDataDriv
enQueryTask_1' succeeded
Step Execution Started: 2006-03-28 11:07:43 AM
Step Execution Completed: 2006-03-28 11:07:43 AM
Total Step Execution Time: 0.015 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteS
QLTask_1' succeeded
Step Execution Started: 2006-03-28 11:07:43 AM
Step Execution Completed: 2006-03-28 11:07:43 AM
Total Step Execution Time: 0 seconds
Progress count in Step: 0
********************
********************
********************
********************
********************
The execution of the following DTS Package succeeded:
Package Name: CTR340 UpLoad HistDoc
Package Description: TEST
Package ID: {D2B54CA5-DA05-44DA-BD81-73EB7637A483}
Package Version: {75B5B912-4538-4135-A6D3-67A17A810C62}
Package Execution Lineage: {0BCA7D06-650A-4E2F-8A26-9A0D3DEE76C7}
Executed On: TESTSERVER
Executed By: usertest
Execution Started: 2006-03-28 11:07:43 AM
Execution Completed: 2006-03-28 11:07:48 AM
Total Execution Time: 4.969 seconds
Package Steps execution information:
Step 'DTSStep_DTSDataPump
Task_12' succeeded
Step Execution Started: 2006-03-28 11:07:45 AM
Step Execution Completed: 2006-03-28 11:07:47 AM
Total Step Execution Time: 2.906 seconds
Progress count in Step: 0
Step 'DTSStep_DTSDataDriv
enQueryTask_1' succeeded
Step Execution Started: 2006-03-28 11:07:47 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 0.031 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteS
QLTask_1' succeeded
Step Execution Started: 2006-03-28 11:07:48 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 0 seconds
Progress count in Step: 0
********************
********************
********************
********************
********************
The execution of the following DTS Package succeeded:
Package Name: CTR340 Upload TruckLoad
Package Description: TEST
Package ID: {64A3822D-ED67-4AB7-90DB-1251EFD1C0F3}
Package Version: {B7283C69-A5B9-4018-92F5-1D538100DCD4}
Package Execution Lineage: {37D77722-BC25-41B0-BFB1-B3579395577C}
Executed On: TESTSERVER
Executed By: usertest
Execution Started: 2006-03-28 11:07:41 AM
Execution Completed: 2006-03-28 11:07:48 AM
Total Execution Time: 7.125 seconds
Package Steps execution information:
Step 'DTSStep_DTSDataPump
Task_7' succeeded
Step Execution Started: 2006-03-28 11:07:43 AM
Step Execution Completed: 2006-03-28 11:07:45 AM
Total Step Execution Time: 2.109 seconds
Progress count in Step: 0
Step 'DTSStep_DTSDataPump
Task_1' succeeded
Step Execution Started: 2006-03-28 11:07:45 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 2.844 seconds
Progress count in Step: 0
Step 'DTSStep_DTSDataDriv
enQueryTask_1' succeeded
Step Execution Started: 2006-03-28 11:07:48 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 0.047 seconds
Progress count in Step: 0
Step 'DTSStep_DTSDataDriv
enQueryTask_2' succeeded
Step Execution Started: 2006-03-28 11:07:48 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 0.031 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteS
QLTask_1' succeeded
Step Execution Started: 2006-03-28 11:07:48 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 0.016 seconds
Progress count in Step: 0
********************
********************
********************
********************
********************
The execution of the following DTS Package succeeded:
Package Name: CTR340 Upload TruckInventory
Package Description: TEST
Package ID: {A7D13900-1692-4B87-B169-B19F0A842D76}
Package Version: {DEE16806-976D-405C-89C1-39326FAFBAC4}
Package Execution Lineage: {4295C8C5-5F56-4A27-9483-73F129AC80CB}
Executed On: TESTSERVER
Executed By: usertest
Execution Started: 2006-03-28 11:07:41 AM
Execution Completed: 2006-03-28 11:07:48 AM
Total Execution Time: 7.235 seconds
Package Steps execution information:
Step 'DTSStep_DTSDataPump
Task_6' succeeded
Step Execution Started: 2006-03-28 11:07:45 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 2.797 seconds
Progress count in Step: 0
Step 'DTSStep_DTSDataPump
Task_13' succeeded
Step Execution Started: 2006-03-28 11:07:43 AM
Step Execution Completed: 2006-03-28 11:07:45 AM
Total Step Execution Time: 2.297 seconds
Progress count in Step: 0
Step 'DTSStep_DTSDataDriv
enQueryTask_1' succeeded
Step Execution Started: 2006-03-28 11:07:48 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 0.032 seconds
Progress count in Step: 0
Step 'DTSStep_DTSDataDriv
enQueryTask_2' succeeded
Step Execution Started: 2006-03-28 11:07:48 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 0.031 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteS
QLTask_1' succeeded
Step Execution Started: 2006-03-28 11:07:48 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 0.016 seconds
Progress count in Step: 0
********************
********************
********************
********************
********************
The execution of the following DTS Package succeeded:
Package Name: CTR340 Upload Com
Package Description: TEST
Package ID: {884BE334-07DB-4243-8339-36FF3EFF6927}
Package Version: {101A3CDC-8072-4A70-BA77-2B356EEF4BA2}
Package Execution Lineage: {92C95015-11EE-4E1E-A2AE-D90B7956FDA3}
Executed On: TESTSERVER
Executed By: usertest
Execution Started: 2006-03-28 11:07:39 AM
Execution Completed: 2006-03-28 11:07:48 AM
Total Execution Time: 9.594 seconds
Package Steps execution information:
Step 'DTSStep_DTSDataPump
Task_1' succeeded
Step Execution Started: 2006-03-28 11:07:43 AM
Step Execution Completed: 2006-03-28 11:07:43 AM
Total Step Execution Time: 0.265 seconds
Progress count in Step: 0
Step 'DTSStep_DTSDataPump
Task_2' succeeded
Step Execution Started: 2006-03-28 11:07:43 AM
Step Execution Completed: 2006-03-28 11:07:45 AM
Total Step Execution Time: 2.281 seconds
Progress count in Step: 0
Step 'DTSStep_DTSDataPump
Task_11' succeeded
Step Execution Started: 2006-03-28 11:07:45 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 2.891 seconds
Progress count in Step: 0
Step 'DTSStep_DTSDataDriv
enQueryTask_1' succeeded
Step Execution Started: 2006-03-28 11:07:48 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 0.031 seconds
Progress count in Step: 0
Step 'DTSStep_DTSDataDriv
enQueryTask_2' succeeded
Step Execution Started: 2006-03-28 11:07:48 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 0.016 seconds
Progress count in Step: 0
Step 'DTSStep_DTSDataDriv
enQueryTask_3' succeeded
Step Execution Started: 2006-03-28 11:07:48 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 0.031 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteS
QLTask_1' succeeded
Step Execution Started: 2006-03-28 11:07:48 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 0.016 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteS
QLTask_2' succeeded
Step Execution Started: 2006-03-28 11:07:41 AM
Step Execution Completed: 2006-03-28 11:07:43 AM
Total Step Execution Time: 2.016 seconds
Progress count in Step: 0
********************
********************
********************
********************
********************
The execution of the following DTS Package succeeded:
Package Name: CTR340 UpLoad MASTER
Package Description: TEST
Package ID: {433EBDD3-2991-452A-AC04-117E6452F449}
Package Version: {90980C6E-EEB3-422F-BED8-46FBDA1937E8}
Package Execution Lineage: {6B9E8FE6-3E39-470A-8F66-0A916E5EC21D}
Executed On: TESTSERVER
Executed By: usertest
Execution Started: 2006-03-28 11:07:32 AM
Execution Completed: 2006-03-28 11:07:51 AM
Total Execution Time: 18.562 seconds
Package Steps execution information:
Step 'DTSStep_DTSExecuteP
ackageTask_1' succeeded
Step Execution Started: 2006-03-28 11:07:34 AM
Step Execution Completed: 2006-03-28 11:07:41 AM
Total Step Execution Time: 6.953 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteP
ackageTask_3' succeeded
Step Execution Started: 2006-03-28 11:07:34 AM
Step Execution Completed: 2006-03-28 11:07:43 AM
Total Step Execution Time: 8.735 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteP
ackageTask_5' succeeded
Step Execution Started: 2006-03-28 11:07:34 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 13.938 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteP
ackageTask_6' succeeded
Step Execution Started: 2006-03-28 11:07:34 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 13.203 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteP
ackageTask_2' succeeded
Step Execution Started: 2006-03-28 11:07:34 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 13.516 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteP
ackageTask_7' succeeded
Step Execution Started: 2006-03-28 11:07:34 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 13.375 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteP
ackageTask_8' succeeded
Step Execution Started: 2006-03-28 11:07:34 AM
Step Execution Completed: 2006-03-28 11:07:51 AM
Total Step Execution Time: 16.5 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteP
ackageTask_4' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Cannot open a log file of specified name.
Step Error code: 800404E6
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:10100
Step Execution Started: 2006-03-28 11:07:34 AM
Step Execution Completed: 2006-03-28 11:07:48 AM
Total Step Execution Time: 13.375 seconds
Progress count in Step: 0
********************
********************
********************
********************
********************
Any help would be greatly appreciated.
Thanks
--
Message posted via http://www.webservertalk.com
| |
| Satya SKJ 2006-03-29, 7:31 am |
| What does this DTS package do including those 8 steps?
Make sure transaction log is not filled up during this operation.
--
-----------------
Satya SKJ
Visit http://www.sql-server-performance.com for tips and articles on
Performance topic.
"Cismail via webservertalk.com" wrote:
> Hello,
>
> I have a DTS package called 'MASTER' which performs 8 execute DTS package
> tasks.
> There are no workflows defined for 'MASTER'. The 'MASTER' DTS as well as 7 of
> the 8 packages it
> executes all have the same error log file name specified in the logging tab
> of package properties.
> 'MASTER' is scheduled to run every 10 minutes and for the most part works
> fine, except every so often
> I get this 'Cannot open a log file of specified name' error.
>
> Below is the error log text file generated:
> The execution of the following DTS Package succeeded:
>
> Package Name: CTR340 UpLoad VisitSequence
> Package Description: TEST
> Package ID: {60CC92FA-72B5-4B4A-BC64-977DDD046307}
> Package Version: {F1C7BFE3-0753-4FBB-8EE1-D991B5F8CAC5}
> Package Execution Lineage: {FBFB494D-CBD4-4AC0-A9FD-956F90495C40}
> Executed On: TESTSERVER
> Executed By: usertest
> Execution Started: 2006-03-28 11:07:36 AM
> Execution Completed: 2006-03-28 11:07:41 AM
> Total Execution Time: 4.828 seconds
>
> Package Steps execution information:
>
>
> Step 'DTSStep_DTSDataPump
Task_5' succeeded
> Step Execution Started: 2006-03-28 11:07:38 AM
> Step Execution Completed: 2006-03-28 11:07:41 AM
> Total Step Execution Time: 2.375 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSDataDriv
enQueryTask_1' succeeded
> Step Execution Started: 2006-03-28 11:07:41 AM
> Step Execution Completed: 2006-03-28 11:07:41 AM
> Total Step Execution Time: 0.032 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSExecuteS
QLTask_1' succeeded
> Step Execution Started: 2006-03-28 11:07:41 AM
> Step Execution Completed: 2006-03-28 11:07:41 AM
> Total Step Execution Time: 0 seconds
> Progress count in Step: 0
> ********************
********************
********************
********************
********************
> The execution of the following DTS Package succeeded:
>
> Package Name: CTR340 UpLoad BalanceValue
> Package Description: TEST
> Package ID: {18EE3EBC-571A-4D98-855C-E17648BEDAA1}
> Package Version: {FD223267-DB22-4810-8E75-97E1E73772DE}
> Package Execution Lineage: {A29B1E8A-C442-4DF9-A2A9-36D4ED08FC0B}
> Executed On: TESTSERVER
> Executed By: usertest
> Execution Started: 2006-03-28 11:07:38 AM
> Execution Completed: 2006-03-28 11:07:43 AM
> Total Execution Time: 4.594 seconds
>
> Package Steps execution information:
>
>
> Step 'DTSStep_DTSDataPump
Task_4' succeeded
> Step Execution Started: 2006-03-28 11:07:41 AM
> Step Execution Completed: 2006-03-28 11:07:43 AM
> Total Step Execution Time: 2.516 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSDataDriv
enQueryTask_1' succeeded
> Step Execution Started: 2006-03-28 11:07:43 AM
> Step Execution Completed: 2006-03-28 11:07:43 AM
> Total Step Execution Time: 0.015 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSExecuteS
QLTask_1' succeeded
> Step Execution Started: 2006-03-28 11:07:43 AM
> Step Execution Completed: 2006-03-28 11:07:43 AM
> Total Step Execution Time: 0 seconds
> Progress count in Step: 0
> ********************
********************
********************
********************
********************
> The execution of the following DTS Package succeeded:
>
> Package Name: CTR340 UpLoad HistDoc
> Package Description: TEST
> Package ID: {D2B54CA5-DA05-44DA-BD81-73EB7637A483}
> Package Version: {75B5B912-4538-4135-A6D3-67A17A810C62}
> Package Execution Lineage: {0BCA7D06-650A-4E2F-8A26-9A0D3DEE76C7}
> Executed On: TESTSERVER
> Executed By: usertest
> Execution Started: 2006-03-28 11:07:43 AM
> Execution Completed: 2006-03-28 11:07:48 AM
> Total Execution Time: 4.969 seconds
>
> Package Steps execution information:
>
>
> Step 'DTSStep_DTSDataPump
Task_12' succeeded
> Step Execution Started: 2006-03-28 11:07:45 AM
> Step Execution Completed: 2006-03-28 11:07:47 AM
> Total Step Execution Time: 2.906 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSDataDriv
enQueryTask_1' succeeded
> Step Execution Started: 2006-03-28 11:07:47 AM
> Step Execution Completed: 2006-03-28 11:07:48 AM
> Total Step Execution Time: 0.031 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSExecuteS
QLTask_1' succeeded
> Step Execution Started: 2006-03-28 11:07:48 AM
> Step Execution Completed: 2006-03-28 11:07:48 AM
> Total Step Execution Time: 0 seconds
> Progress count in Step: 0
> ********************
********************
********************
********************
********************
> The execution of the following DTS Package succeeded:
>
> Package Name: CTR340 Upload TruckLoad
> Package Description: TEST
> Package ID: {64A3822D-ED67-4AB7-90DB-1251EFD1C0F3}
> Package Version: {B7283C69-A5B9-4018-92F5-1D538100DCD4}
> Package Execution Lineage: {37D77722-BC25-41B0-BFB1-B3579395577C}
> Executed On: TESTSERVER
> Executed By: usertest
> Execution Started: 2006-03-28 11:07:41 AM
> Execution Completed: 2006-03-28 11:07:48 AM
> Total Execution Time: 7.125 seconds
>
> Package Steps execution information:
>
>
> Step 'DTSStep_DTSDataPump
Task_7' succeeded
> Step Execution Started: 2006-03-28 11:07:43 AM
> Step Execution Completed: 2006-03-28 11:07:45 AM
> Total Step Execution Time: 2.109 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSDataPump
Task_1' succeeded
> Step Execution Started: 2006-03-28 11:07:45 AM
> Step Execution Completed: 2006-03-28 11:07:48 AM
> Total Step Execution Time: 2.844 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSDataDriv
enQueryTask_1' succeeded
> Step Execution Started: 2006-03-28 11:07:48 AM
> Step Execution Completed: 2006-03-28 11:07:48 AM
> Total Step Execution Time: 0.047 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSDataDriv
enQueryTask_2' succeeded
> Step Execution Started: 2006-03-28 11:07:48 AM
> Step Execution Completed: 2006-03-28 11:07:48 AM
> Total Step Execution Time: 0.031 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSExecuteS
QLTask_1' succeeded
> Step Execution Started: 2006-03-28 11:07:48 AM
> Step Execution Completed: 2006-03-28 11:07:48 AM
> Total Step Execution Time: 0.016 seconds
> Progress count in Step: 0
> ********************
********************
********************
********************
********************
> The execution of the following DTS Package succeeded:
>
> Package Name: CTR340 Upload TruckInventory
> Package Description: TEST
> Package ID: {A7D13900-1692-4B87-B169-B19F0A842D76}
> Package Version: {DEE16806-976D-405C-89C1-39326FAFBAC4}
> Package Execution Lineage: {4295C8C5-5F56-4A27-9483-73F129AC80CB}
> Executed On: TESTSERVER
> Executed By: usertest
> Execution Started: 2006-03-28 11:07:41 AM
> Execution Completed: 2006-03-28 11:07:48 AM
> Total Execution Time: 7.235 seconds
>
> Package Steps execution information:
>
>
> Step 'DTSStep_DTSDataPump
Task_6' succeeded
> Step Execution Started: 2006-03-28 11:07:45 AM
> Step Execution Completed: 2006-03-28 11:07:48 AM
> Total Step Execution Time: 2.797 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSDataPump
Task_13' succeeded
> Step Execution Started: 2006-03-28 11:07:43 AM
> Step Execution Completed: 2006-03-28 11:07:45 AM
> Total Step Execution Time: 2.297 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSDataDriv
enQueryTask_1' succeeded
> Step Execution Started: 2006-03-28 11:07:48 AM
> Step Execution Completed: 2006-03-28 11:07:48 AM
> Total Step Execution Time: 0.032 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSDataDriv
enQueryTask_2' succeeded
> Step Execution Started: 2006-03-28 11:07:48 AM
> Step Execution Completed: 2006-03-28 11:07:48 AM
> Total Step Execution Time: 0.031 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSExecuteS
QLTask_1' succeeded
> Step Execution Started: 2006-03-28 11:07:48 AM
> Step Execution Completed: 2006-03-28 11:07:48 AM
> Total Step Execution Time: 0.016 seconds
> Progress count in Step: 0
> ********************
********************
********************
********************
********************
> The execution of the following DTS Package succeeded:
>
> Package Name: CTR340 Upload Com
> Package Description: TEST
> Package ID: {884BE334-07DB-4243-8339-36FF3EFF6927}
> Package Version: {101A3CDC-8072-4A70-BA77-2B356EEF4BA2}
> Package Execution Lineage: {92C95015-11EE-4E1E-A2AE-D90B7956FDA3}
> Executed On: TESTSERVER
> Executed By: usertest
> Execution Started: 2006-03-28 11:07:39 AM
> Execution Completed: 2006-03-28 11:07:48 AM
> Total Execution Time: 9.594 seconds
>
> Package Steps execution information:
>
>
> Step 'DTSStep_DTSDataPump
Task_1' succeeded
> Step Execution Started: 2006-03-28 11:07:43 AM
> Step Execution Completed: 2006-03-28 11:07:43 AM
> Total Step Execution Time: 0.265 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSDataPump
Task_2' succeeded
> Step Execution Started: 2006-03-28 11:07:43 AM
> Step Execution Completed: 2006-03-28 11:07:45 AM
> Total Step Execution Time: 2.281 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSDataPump
Task_11' succeeded
> Step Execution Started: 2006-03-28 11:07:45 AM
> Step Execution Completed: 2006-03-28 11:07:48 AM
> Total Step Execution Time: 2.891 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSDataDriv
enQueryTask_1' succeeded
> Step Execution Started: 2006-03-28 11:07:48 AM
> Step Execution Completed: 2006-03-28 11:07:48 AM
> Total Step Execution Time: 0.031 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSDataDriv
enQueryTask_2' succeeded
> Step Execution Started: 2006-03-28 11:07:48 AM
> Step Execution Completed: 2006-03-28 11:07:48 AM
> Total Step Execution Time: 0.016 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSDataDriv
enQueryTask_3' succeeded
> Step Execution Started: 2006-03-28 11:07:48 AM
> Step Execution Completed: 2006-03-28 11:07:48 AM
> Total Step Execution Time: 0.031 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSExecuteS
QLTask_1' succeeded
> Step Execution Started: 2006-03-28 11:07:48 AM
> Step Execution Completed: 2006-03-28 11:07:48 AM
> Total Step Execution Time: 0.016 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSExecuteS
QLTask_2' succeeded
> Step Execution Started: 2006-03-28 11:07:41 AM
> Step Execution Completed: 2006-03-28 11:07:43 AM
> Total Step Execution Time: 2.016 seconds
> Progress count in Step: 0
> ********************
********************
********************
********************
********************
> The execution of the following DTS Package succeeded:
>
> Package Name: CTR340 UpLoad MASTER
> Package Description: TEST
> Package ID: {433EBDD3-2991-452A-AC04-117E6452F449}
> Package Version: {90980C6E-EEB3-422F-BED8-46FBDA1937E8}
> Package Execution Lineage: {6B9E8FE6-3E39-470A-8F66-0A916E5EC21D}
> Executed On: TESTSERVER
> Executed By: usertest
> Execution Started: 2006-03-28 11:07:32 AM
> Execution Completed: 2006-03-28 11:07:51 AM
> Total Execution Time: 18.562 seconds
>
> Package Steps execution information:
>
>
> Step 'DTSStep_DTSExecuteP
ackageTask_1' succeeded
> Step Execution Started: 2006-03-28 11:07:34 AM
> Step Execution Completed: 2006-03-28 11:07:41 AM
> Total Step Execution Time: 6.953 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSExecuteP
ackageTask_3' succeeded
> Step Execution Started: 2006-03-28 11:07:34 AM
> Step Execution Completed: 2006-03-28 11:07:43 AM
> Total Step Execution Time: 8.735 seconds
> Progress count in Step: 0
>
> Step 'DTSStep_DTSExecuteP
ackageTask_5' succeeded
| |
| Cismail via SQLMonster.com 2006-03-29, 1:29 pm |
| Hi Satya,
The DTS package called 'MASTER' just executes 8 other DTS packages.
The 8 DTS packages transfer data from the server(SQL server) to the AS400
using the transform data task.
What do you mean by make sure transaction log is not filled up??
Satya SKJ wrote:[color=darkred
]
>What does this DTS package do including those 8 steps?
>Make sure transaction log is not filled up during this operation.
>[quoted text clipped - 289 lines]
--
Message posted via http://www.webservertalk.com
| |
|
| Try this:
go to Enterprise Manager for that server and look at:
Management->Sql Server Logs->Current.
On the 'current' view do refresh and look for errors such as 'Log is full'
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)
"Cismail via webservertalk.com" wrote:
> Hi Satya,
>
> The DTS package called 'MASTER' just executes 8 other DTS packages.
> The 8 DTS packages transfer data from the server(SQL server) to the AS400
> using the transform data task.
>
> What do you mean by make sure transaction log is not filled up??
>
> Satya SKJ wrote:
>
> --
> Message posted via http://www.webservertalk.com
>
|
|
|
|