Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to 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 16-Aug-12 9:29am
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

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
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 4

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.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

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.
  Permalink  
Comments
Kuthuparakkal at 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)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 575
1 Kornfeld Eliyahu Peter 409
2 Maciej Los 369
3 DamithSL 196
4 OriginalGriff 188
0 OriginalGriff 6,353
1 DamithSL 4,854
2 Maciej Los 4,476
3 Kornfeld Eliyahu Peter 4,058
4 Sergey Alexandrovich Kryukov 3,917


Advertise | Privacy | Mobile
Web02 | 2.8.141223.1 | Last Updated 29 Aug 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100