Fetching Progress tab result in text file in SSIS.

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

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.

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.