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