Setting Log File Dynamically in SQL Server 2000 DTS

February 20th, 2006 // 5:25 pm @ Amar

Very often there are cases when we want to have our DTS package to log error at a different path or file. This can very easily be achieved in the following way…

Read the log file path from a config file and store it to a global variable called ErrorLogFile using the Dynamic Properties Task.

Set the Package’s error log to the new value using ActiveX scripting.

set oPackage = DTSGlobalVariables.Parent oPackage.Properties(“LogFileName”).Value = DTSGlobalVariables(“ErrorLogFile”).Value

Category : SQL Server

Latest Posts

Migrating to Office 365
by Amar on July 29, 2011
Office 365 now available to purchase
by Amar on June 28, 2011
Visual Studio 2010 code formatting bug
by Amar on February 25, 2011
Happy New Year
by Amar on January 4, 2011
Ultimate SharePoint 2010 Development Rig
by Amar on October 4, 2010

Testimonials

"Amar clearly has a thorough knowledge of Sharepoint, this knowledge, coupled with his professionalism and dedication made him a tremendous asset to the project. He was the key contributor to the later stages of the project delivery effort (the really difficult bit, long hours and hard work that puts huge demands on people), and I can state categorically that without his focussed dedication and hard work we would not have been able to meet the timescales imposed upon the project."

Tim Ellis , Sharepoint Project Manager , Royal Bank of Scotland

Setting Log File Dynamically in SQL Server 2000 DTS