Click here to Skip to main content
13,147,629 members (30,535 online)
Rate this:
 
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 8: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 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
Top Experts
Last 24hrsThis month


Advertise | Privacy |
Web02 | 2.8.170915.1 | Last Updated 29 Aug 2012
Copyright © CodeProject, 1999-2017
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