I have a DTS with some "transfer data task"s. To get a succesfull run of the
dts, some properties have to be set dynamically, so i added also a "dynamic
properties task". i use beside 1 global variable also an INI file, and that
causes a problem.

In this INI-file i have 1 section and in this section ±30 keys. When i click
the Add-button in the "dynamic properties task", i choose my ini-file, choose
the section and i get a summary of all the keys, BUT instead of all the keys,
i got only 25 keys and the 26th key misses a few characters (knp_w instead of
knp_werv) and all the other keys aren't displayed. When i typ it manually, it
says "Can't find key", but it's really in it. When i try to run DTS, it fails
due to the error of "can't find key"

When i create 4 sections in the ini-file and i have 8 keys per section,
every key is displayed as it supposed to be and the appropriate value is used.

I use SQL Server 2000 Enterprise Edition

did some more experiments: if i remove for example 2 characters of a previous
key the last key is knp_wer (instead of knp_w, as stated in my previous
message). So for some reason he truncates the keys to a certain length.

So the sum og the length of all keys of 1 section must be less then 229,
otherwise it's truncated and it won't work. It's again some strange MS
behavior that is not documented anywhere.

"hysterio" schreef: