 | |
dts log file
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
dts log file -
04-15-2004
, 07:41 AM
#2
| |||
| |||
|
|
hi to all. I'm executing 'DTSRun' in command prompt. DTS package contains calls to 3 subpackages each of them has about 10-15 tables to run data transfer. The problem is that if any of the tables failed for any reason I can only see the errors in the dos command window, but not in the log file(example below). I only get general information about the package and steps execution time and rows transfered. Is there a way to write all the errors generated in the log file. Thanx in advance, Alex Frisman log file: __________________________________________________ ____________ The execution of the following DTS Package succeeded: Package Name: KCCMS_2.5.10_pharm Package Description: (null) Package ID: {7CAB9AB0-5CA3-4B29-A730-1B34652514C5} Package Version: {5F4AEBD9-4350-4C0F-A8A8-7027F54AD160} Package Execution Lineage: {CC72925B-E413-4ECE-A363-310441C74B00} Executed On: RETAIL_WEB_TEST Executed By: Administrator Execution Started: 3/30/2004 8:44:37 AM Execution Completed: 3/30/2004 8:45:31 AM Total Execution Time: 54.171 seconds Package Steps execution information: Step 'DTSStep_DTSExecutePackageTask_1' succeeded Step Execution Started: 3/30/2004 8:44:37 AM Step Execution Completed: 3/30/2004 8:44:49 AM Total Step Execution Time: 11.937 seconds Progress count in Step: 1 Step 'DTSStep_DTSExecutePackageTask_2' succeeded Step Execution Started: 3/30/2004 8:44:49 AM Step Execution Completed: 3/30/2004 8:45:00 AM Total Step Execution Time: 11.422 seconds Progress count in Step: 12333 Step 'DTSStep_DTSExecutePackageTask_3' succeeded Step Execution Started: 3/30/2004 8:45:00 AM Step Execution Completed: 3/30/2004 8:45:12 AM Total Step Execution Time: 11.969 seconds Progress count in Step: 77 __________________________________________________ ______ |
#3
| |||
| |||
|
|
Have the subpackages to log to the files too. Ilya "Alex" <afrisman (AT) retailexpert (DOT) com> wrote in message news:OjZjqbuIEHA.3512 (AT) TK2MSFTNGP10 (DOT) phx.gbl... hi to all. I'm executing 'DTSRun' in command prompt. DTS package contains calls to 3 subpackages each of them has about 10-15 tables to run data transfer. The problem is that if any of the tables failed for any reason I can only see the errors in the dos command window, but not in the log file(example below). I only get general information about the package and steps execution time and rows transfered. Is there a way to write all the errors generated in the log file. Thanx in advance, Alex Frisman log file: __________________________________________________ ____________ The execution of the following DTS Package succeeded: Package Name: KCCMS_2.5.10_pharm Package Description: (null) Package ID: {7CAB9AB0-5CA3-4B29-A730-1B34652514C5} Package Version: {5F4AEBD9-4350-4C0F-A8A8-7027F54AD160} Package Execution Lineage: {CC72925B-E413-4ECE-A363-310441C74B00} Executed On: RETAIL_WEB_TEST Executed By: Administrator Execution Started: 3/30/2004 8:44:37 AM Execution Completed: 3/30/2004 8:45:31 AM Total Execution Time: 54.171 seconds Package Steps execution information: Step 'DTSStep_DTSExecutePackageTask_1' succeeded Step Execution Started: 3/30/2004 8:44:37 AM Step Execution Completed: 3/30/2004 8:44:49 AM Total Step Execution Time: 11.937 seconds Progress count in Step: 1 Step 'DTSStep_DTSExecutePackageTask_2' succeeded Step Execution Started: 3/30/2004 8:44:49 AM Step Execution Completed: 3/30/2004 8:45:00 AM Total Step Execution Time: 11.422 seconds Progress count in Step: 12333 Step 'DTSStep_DTSExecutePackageTask_3' succeeded Step Execution Started: 3/30/2004 8:45:00 AM Step Execution Completed: 3/30/2004 8:45:12 AM Total Step Execution Time: 11.969 seconds Progress count in Step: 77 __________________________________________________ ______ |
#4
| |||
| |||
|
|
Hi, Is there any way that I can set in the DTS package to log information on every step executed while it is executing. For example, I have a DTS package that has 12 SQL Execute tasks. The entire DTS package takes 7 hrs to execute. I have set the looging option in the DTS but the problem is that when I run this DTS Package as a job, it writes the log file only after the job is finished executing. I want to know which steps have been executed in the package while it is still executing as a job. -- Thanks Akber. |
#5
| |||
| |||
|
|
What happens if you log then to SQL Server instead? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Akber" <Akber (AT) discussions (DOT) microsoft.com> wrote in message news:F60EA8F5-157C-4EE7-9340-98DCD4EEDD62 (AT) microsoft (DOT) com... Hi, Is there any way that I can set in the DTS package to log information on every step executed while it is executing. For example, I have a DTS package that has 12 SQL Execute tasks. The entire DTS package takes 7 hrs to execute. I have set the looging option in the DTS but the problem is that when I run this DTS Package as a job, it writes the log file only after the job is finished executing. I want to know which steps have been executed in the package while it is still executing as a job. -- Thanks Akber. |
#6
| |||
| |||
|
|
Allan! I can't understand your comment "Allan Mitchell" wrote: What happens if you log then to SQL Server instead? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Akber" <Akber (AT) discussions (DOT) microsoft.com> wrote in message news:F60EA8F5-157C-4EE7-9340-98DCD4EEDD62 (AT) microsoft (DOT) com... Hi, Is there any way that I can set in the DTS package to log information on every step executed while it is executing. For example, I have a DTS package that has 12 SQL Execute tasks. The entire DTS package takes 7 hrs to execute. I have set the looging option in the DTS but the problem is that when I run this DTS Package as a job, it writes the log file only after the job is finished executing. I want to know which steps have been executed in the package while it is still executing as a job. -- Thanks Akber. |
#7
| |||
| |||
|
|
In the package properties you can choose to log to SQL Server instead of text file. This will also log Step and Task execution -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Akber" <Akber (AT) discussions (DOT) microsoft.com> wrote in message news:AB5C3803-7558-4591-B544-0C450E56285F (AT) microsoft (DOT) com... Allan! I can't understand your comment "Allan Mitchell" wrote: What happens if you log then to SQL Server instead? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Akber" <Akber (AT) discussions (DOT) microsoft.com> wrote in message news:F60EA8F5-157C-4EE7-9340-98DCD4EEDD62 (AT) microsoft (DOT) com... Hi, Is there any way that I can set in the DTS package to log information on every step executed while it is executing. For example, I have a DTS package that has 12 SQL Execute tasks. The entire DTS package takes 7 hrs to execute. I have set the looging option in the DTS but the problem is that when I run this DTS Package as a job, it writes the log file only after the job is finished executing. I want to know which steps have been executed in the package while it is still executing as a job. -- Thanks Akber. |
#8
| |||
| |||
|
|
Allan it is not working. The log file is not being created int the SQL Server Logs section. Is there any other option that is to be set to enable it. I am setting the option in the Package properties logging tab. "Allan Mitchell" wrote: In the package properties you can choose to log to SQL Server instead of text file. This will also log Step and Task execution -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Akber" <Akber (AT) discussions (DOT) microsoft.com> wrote in message news:AB5C3803-7558-4591-B544-0C450E56285F (AT) microsoft (DOT) com... Allan! I can't understand your comment "Allan Mitchell" wrote: What happens if you log then to SQL Server instead? -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com - Consultancy from the people who know "Akber" <Akber (AT) discussions (DOT) microsoft.com> wrote in message news:F60EA8F5-157C-4EE7-9340-98DCD4EEDD62 (AT) microsoft (DOT) com... Hi, Is there any way that I can set in the DTS package to log information on every step executed while it is executing. For example, I have a DTS package that has 12 SQL Execute tasks. The entire DTS package takes 7 hrs to execute. I have set the looging option in the DTS but the problem is that when I run this DTS Package as a job, it writes the log file only after the job is finished executing. I want to know which steps have been executed in the package while it is still executing as a job. -- Thanks Akber. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.