提取进度选项卡将在SSIS中生成文本文件. [英] Fetching Progress tab result in text file in SSIS.

问题描述

你好，

在我的项目中，我必须将进度选项卡/执行结果选项卡的详细信息提取到文本文件中.我无法使用tablea进行日志记录.

谁能告诉我我该怎么做?
请给我您的建议.

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.

推荐答案

您可以在DTEXEC的命令行中进行选择.简称为/Reporting或/Rep的开关.使用P选项会将进度捕获到控制台.使用竖线字符>"将允许您通过管道传输到文本文件.

例如:DTEXEC/F ssisexample.dtsx/Rep P> progress.txt.

谢谢，

Kuthuparakkal

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

创建BAT文件，添加以下内容...

1. DTEXEC路径，最常见的位置； C:\ Program Files \ Microsoft SQL Server \ 100 \ DTS \ Binn \ dtexec.exe

2.您的软件包位置，示例:D:\ Packages \ Fact_Build_Master.dtsx

3.您想在哪里存储日志，示例: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"

现在执行bat文件，看看是否已填写日志.

谢谢，

Kuthuparakkal

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

专家们，

我得到了一个由其他开发人员在不同项目中创建的文件，但我不知道他是如何创建的.我在下面提到.请让我了解如何捕获此文件，我尝试使用DTEXEC/F ssisexample.dtsx/Rep P> progress.txt.但是它没有以以下格式提供我.
++++++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++++++++++++++++++

Microsoft(R)SQL Server执行程序包实用程序
适用于32位的10.0.5500.0版
版权所有(C)Microsoft Corp 1984-2005.保留所有权利.

开始时间:下午5:20:42
进度:2012-08-21 17:20:42.95
来源:数据流任务
验证:0％完成
最终进度
进度:2012-08-21 17:20:42.95
来源:数据流任务
验证:已完成50％
最终进度
进度:2012-08-21 17:20:42.95
来源:数据流任务
验证:100％完成
最终进度
进度:2012-08-21 17:20:43.00
来源:数据流任务
验证:0％完成
最终进度
进度:2012-08-21 17:20:43.00
来源:数据流任务
验证:已完成50％
最终进度
进度:2012-08-21 17:20:43.00
来源:数据流任务
验证:100％完成
最终进度
警告:2012-08-21 17:20:43.00
代码:0x80049304
来源:数据流任务SSIS.Pipeline
说明:警告:无法打开全局共享内存与性能DLL进行通讯；数据流性能计数器不可用.要解决此问题，请以管理员身份或在系统控制台上运行此程序包.
结束警告
进度:2012-08-21 17:20:43.01
来源:数据流任务
准备执行:0％完成
最终进度
进度:2012-08-21 17:20:43.01
来源:数据流任务
准备执行:50％完成
最终进度
进度:2012-08-21 17:20:43.01
来源:数据流任务
准备执行:100％完成
最终进度
进度:2012-08-21 17:20:43.01
来源:数据流任务
预先执行:0％完成
最终进度
进度:2012-08-21 17:20:43.01
来源:数据流任务
预执行:50％完成
最终进度
进度:2012-08-21 17:20:43.03
来源:数据流任务
预先执行:100％完成
最终进度
进度:2012-08-21 17:20:43.03
来源:数据流任务
发布执行:0％完成
最终进度
进度:2012-08-21 17:20:43.03
来源:数据流任务
发布执行:50％完成
最终进度
进度:2012-08-21 17:20:43.03
来源:数据流任务
发布执行:100％完成
最终进度
进度:2012-08-21 17:20:43.03
来源:数据流任务
清除:0％完成
最终进度
进度:2012-08-21 17:20:43.03
来源:数据流任务
清理:50％完成
最终进度
进度:2012-08-21 17:20:43.03
来源:数据流任务
清理:100％完成
最终进度
进度:2012-08-21 17:20:43.06
来源:文件系统任务
操作完成:100％完成
最终进度
进度:2012-08-21 17:20:43.06
来源:文件系统任务
操作完成:100％完成
最终进度
进度:2012-08-21 17:20:43.06
来源:文件系统任务
操作完成:100％完成
最终进度
进度:2012-08-21 17:20:43.06
来源:文件系统任务
操作完成:100％完成
最终进度
进度:2012-08-21 17:20:43.06
来源:文件系统任务
操作完成:100％完成
最终进度
进度:2012-08-21 17:20:43.07
来源:文件系统任务
操作完成:100％完成
最终进度
进度:2012-08-21 17:20:43.07
来源:文件系统任务
操作完成:100％完成
最终进度
进度:2012-08-21 17:20:43.07
来源:文件系统任务
操作完成:100％完成
最终进度
DTExec:程序包执行返回DTSER_SUCCESS(0).
开始时间:下午5:20:42
已完成:下午5:20:43
耗时:0.64秒
++++++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++

请帮帮我.
谢谢.

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.

这篇关于提取进度选项卡将在SSIS中生成文本文件.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！