INI File limitations in DTS

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

SQL Server 2000 DTS has a nice little Dynamic Properties task. But its usefulness for INI files is limited by some stupid limitations ( bugs/ features ) of the size of data in the INI files. To overcome it, the only possible solution I found was to write a custom ini file parser script and use it to directly retrieve values form the INI files. Fortunately I found a very nice script by Nolan Bagadiogn which uses regular exceptions and does not get limited in any way on number of spaces between keywords and values. Use this in an ActiveX Scripting Task, and enjoy

For reference, you can download it from
http://cwashington.netreach.net/depo/view.asp?Index=553&ScriptType=vbscript

Nolan, thanks for the nice script. It is very much appreciated.

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

INI File limitations in DTS