Generate SSIS log using dtexec 生成SSIS 日志

Generate SSIS log using dtexec 生成SSIS 日志

Categories: Database; Tagged with: ETL • SQL • SQL Server • SSIS; @ October 9th, 2012 20:11

First we need to Config logging in SSIS package(GUI):

Two methods to generate the log:

1. Using SSIS ‘Connection’ to sotre the log;

Example:
dtexec /f DavidTest.dtsx /l “DTS.LogProviderTextFile;log.txt”
(log.txt is a Connection in SSIS package).

2. Redirect console message into a file:

dtexec /f DavidTest.dtsx /cons NMT >C:/ConsoleMsg.log

About the dtexec parameters:
http://msdn.microsoft.com/en-us/library/hh231187.aspx
SSIS Logging:
http://weblogs.sqlteam.com/jamesn/archive/2008/02/11/60502.aspx

How to add Simple Logging to an SSIS Package

2012/10/5 <-> SQL Server: 用户登录失败Login failed, The user is not associated with a trusted SQL Server connection(Error: 18452)

// Proudly powered by Apache, PHP, MySQL, WordPress, Bootstrap, etc,.