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_DTSDataPumpTask_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_DTSDataDrivenQueryTask_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_DTSExecuteSQLTask_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_DTSDataPumpTask_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_DTSDataDrivenQueryTask_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_DTSExecuteSQLTask_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_DTSDataPumpTask_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_DTSDataDrivenQueryTask_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_DTSExecuteSQLTask_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_DTSDataPumpTask_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_DTSDataPumpTask_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_DTSDataDrivenQueryTask_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_DTSDataDrivenQueryTask_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_DTSExecuteSQLTask_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_DTSDataPumpTask_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_DTSDataPumpTask_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_DTSDataDrivenQueryTask_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_DTSDataDrivenQueryTask_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_DTSExecuteSQLTask_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_DTSDataPumpTask_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_DTSDataPumpTask_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_DTSDataPumpTask_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_DTSDataDrivenQueryTask_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_DTSDataDrivenQueryTask_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_DTSDataDrivenQueryTask_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_DTSExecuteSQLTask_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_DTSExecuteSQLTask_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_DTSExecutePackageTask_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_DTSExecutePackageTask_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_DTSExecutePackageTask_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_DTSExecutePackageTask_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_DTSExecutePackageTask_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_DTSExecutePackageTask_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_DTSExecutePackageTask_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_DTSExecutePackageTask_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.sqlmonster.com

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 SQLMonster.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.sqlmonster.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 SQLMonster.com" wrote: