Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2009-12-03 : 06:28:23
|
| Dear All,I am new to SSIS package and i need to enable SSIS logging capabilities to include all of the events for each executable within the package.How can we achieve this,currently we are doing like this "we are creating batch file with the the following details dtexec /F .\PackageName.dtsx >> .\LogName.logPlease suggest how can we log all the events associated with the package execution similar to execution from Visual Studio Business Intelligence Development from solution.Thanks,Gangadhar |
|
|
goodsolution
Starting Member
38 Posts |
Posted - 2009-12-14 : 15:50:35
|
| Here is the procedure, first you go to Control Flow --> Click on SSIS tab --> Click Logging --> Select Check box on left --> Click Add button --> Select the check box of Name (SSIS Log provider ...) --> Go to Details tab --> Click the check boxes what you need --> then click load button --> Give the path where you want to load that log file --> Click Save button and then run the whole package and check for the perticular log file to see the messages. -Thanks |
 |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-12-14 : 17:43:12
|
You can use the "Rep" statement within dtexec to report pretty much everything you need...something like...dtexec /f ".\package.dtsx" /Rep EWPD >\\uncpath\Logname.logEWPD are options that we use...Here's the entire list. N No reporting.E Errors are reported.W Warnings are reported.I Informational messages are reported.C Custom events are reported.D Data Flow task events are reported.P Progress is reported.V Verbose reporting. You can check this link and go down to /Rep[orting] for more info..http://msdn.microsoft.com/en-us/library/ms162810.aspx |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
SSIS Package Logging