Click here to Skip to main content
16,017,745 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
Hello,

In my project I have to fetch the progress tab/ Execution result tab detail into text file.I could not use tablea for the logging.

Can anyone tell how i can do this?
please give me your suggestion.
Posted

You have an option at DTEXEC at the command-line. There is a switch called /Reporting or /Rep for short. Using the P option will capture the Progress to the console. Using the pipe character ">" will allow you to pipe to a text file.

For example: DTEXEC /F ssisexample.dtsx /Rep P > progress.txt.

Thanks,

Kuthuparakkal
 
Share this answer
 
Create a BAT file add the following...

1. DTEXEC path, most common location ; C:\Program Files\Microsoft SQL Server\100\DTS\Binn\dtexec.exe

2. Your package location, sample : D:\Packages\Fact_Build_Master.dtsx

3. Where do you want to store log, sample : D:\Packages\Logs\Fact_Build_Master.log

@ECHO OFF
"E:\commonapps\Microsoft SQL Server\100\DTS\Binn\dtexec.exe" /FILE "D:\Packages\Fact_Build_Master.dtsx" /REP P >> "D:\Packages\Logs\Fact_Build_Master.log"

Now execute bat file see if you have logs filled in.

Thanks,

Kuthuparakkal
 
Share this answer
 
Hi Experts,

I got one file which is created by other developer in different project, but I dont know how he created. I have mentioned below. please let me how I can capture this file, I tried with DTEXEC /F ssisexample.dtsx /Rep P > progress.txt. but Its didn't provide me in the following format.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Microsoft (R) SQL Server Execute Package Utility
Version 10.0.5500.0 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 5:20:42 PM
Progress: 2012-08-21 17:20:42.95
Source: Data Flow Task
Validating: 0% complete
End Progress
Progress: 2012-08-21 17:20:42.95
Source: Data Flow Task
Validating: 50% complete
End Progress
Progress: 2012-08-21 17:20:42.95
Source: Data Flow Task
Validating: 100% complete
End Progress
Progress: 2012-08-21 17:20:43.00
Source: Data Flow Task
Validating: 0% complete
End Progress
Progress: 2012-08-21 17:20:43.00
Source: Data Flow Task
Validating: 50% complete
End Progress
Progress: 2012-08-21 17:20:43.00
Source: Data Flow Task
Validating: 100% complete
End Progress
Warning: 2012-08-21 17:20:43.00
Code: 0x80049304
Source: Data Flow Task SSIS.Pipeline
Description: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console.
End Warning
Progress: 2012-08-21 17:20:43.01
Source: Data Flow Task
Prepare for Execute: 0% complete
End Progress
Progress: 2012-08-21 17:20:43.01
Source: Data Flow Task
Prepare for Execute: 50% complete
End Progress
Progress: 2012-08-21 17:20:43.01
Source: Data Flow Task
Prepare for Execute: 100% complete
End Progress
Progress: 2012-08-21 17:20:43.01
Source: Data Flow Task
Pre-Execute: 0% complete
End Progress
Progress: 2012-08-21 17:20:43.01
Source: Data Flow Task
Pre-Execute: 50% complete
End Progress
Progress: 2012-08-21 17:20:43.03
Source: Data Flow Task
Pre-Execute: 100% complete
End Progress
Progress: 2012-08-21 17:20:43.03
Source: Data Flow Task
Post Execute: 0% complete
End Progress
Progress: 2012-08-21 17:20:43.03
Source: Data Flow Task
Post Execute: 50% complete
End Progress
Progress: 2012-08-21 17:20:43.03
Source: Data Flow Task
Post Execute: 100% complete
End Progress
Progress: 2012-08-21 17:20:43.03
Source: Data Flow Task
Cleanup: 0% complete
End Progress
Progress: 2012-08-21 17:20:43.03
Source: Data Flow Task
Cleanup: 50% complete
End Progress
Progress: 2012-08-21 17:20:43.03
Source: Data Flow Task
Cleanup: 100% complete
End Progress
Progress: 2012-08-21 17:20:43.06
Source: File System Task
Operation Complete: 100% complete
End Progress
Progress: 2012-08-21 17:20:43.06
Source: File System Task
Operation Complete: 100% complete
End Progress
Progress: 2012-08-21 17:20:43.06
Source: File System Task
Operation Complete: 100% complete
End Progress
Progress: 2012-08-21 17:20:43.06
Source: File System Task
Operation Complete: 100% complete
End Progress
Progress: 2012-08-21 17:20:43.06
Source: File System Task
Operation Complete: 100% complete
End Progress
Progress: 2012-08-21 17:20:43.07
Source: File System Task
Operation Complete: 100% complete
End Progress
Progress: 2012-08-21 17:20:43.07
Source: File System Task
Operation Complete: 100% complete
End Progress
Progress: 2012-08-21 17:20:43.07
Source: File System Task
Operation Complete: 100% complete
End Progress
DTExec: The package execution returned DTSER_SUCCESS (0).
Started: 5:20:42 PM
Finished: 5:20:43 PM
Elapsed: 0.64 seconds
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Please Help me.
Thank you.
 
Share this answer
 
Hi,

I new to SSIS, so could you please tell me how can i use this.I have to develop the same functionality in my project.

Thanks for your reply.
 
Share this answer
 
Comments
Kuthuparakkal 23-Aug-12 0:05am    
see my answer with descriptions

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900