SQL Server Performance Forum – Threads Archive
Creating log for PackageHi I have created a DTS package as Say ParentPackage.
In that i have 4 tasks 1. Execute batch file, copytables.bat(execute processtask)
2. Create tables (Execute sql task)
3. execute another package childPackage(execute package task)
4. execute a SP TransferMaster (execute sql task) Alog file is created for the batch fle errors ,and a seperate log file is created for childPackage as CheilPackage_errorLog.txt I want to store all these things in one log file, also while executing the TransferMaster some messages are printed, like ‘Executing procedure Transfercompany’, ‘12345 records transfred from Company’ etc. I want these msg to be in the log file. Can any one tell me how i can do this? Regards!
http://vyaskn.tripod.com/sql_server_dts_error_file.htm for information. BOL states:
To enable package logging Open the Data Transformation Services (DTS) package for which you want to create a log.
On the Package menu, click Properties to display the DTS Package Properties dialog box.
Do one of the following:
Save package logs to MicrosoftÂ® SQL Serverâ„¢ by clicking the Logging tab, selecting the Log package execution to SQLServer check box, and then clicking an available server on which to save the package logs.
Security Note When possible, use Windows Authentication. Save package logs to SQL Server 2000 Meta Data Services by clicking the Advanced tab, and then selecting the Show lineage variables as source columns and Write lineage to repository check boxes. On the Package menu, click Save As, and then in the Save DTS Package dialog box, in the Location list, select Meta Data Services. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.