dbTalk Databases Forums  

INI file size limitations in Dynamic Properties Task?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss INI file size limitations in Dynamic Properties Task? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mike van de Vijsel
 
Posts: n/a

Default INI file size limitations in Dynamic Properties Task? - 10-08-2003 , 01:23 PM






Hello,

I have a series of related DTS packages and I want to use
one .ini file to drive all the Dynamic Property tasks for
all of them.

Once I get to approx. 5K in my .ini file, I seem to hit a
size limitation. The Section drop-down list in the
Add/Edit Assignment dialog box truncates one of the
section names that appears near the end of the .ini file,
and doesn't display any section names appearing further
down in the file. If I re-order the section names, the one
in the same position that was previously truncated is now
truncated, and later section names still don't appear.

Is there a size limitation on the .ini file in a Dynamic
Property task?

Thanks for your help,

Mike van de Vijsel

Reply With Quote
  #2  
Old   
Sanka
 
Posts: n/a

Default INI file size limitations in Dynamic Properties Task? - 10-08-2003 , 01:43 PM






It seems to be a problem with the GUI for DTS. If you work
programmatically the size of the INI file is limited by
the WIN32 API (which is some big number like 65K).

The following link
http://www.interclasse.com/scripts/class_ini.php has got
some sample source code.

Have a activex script at the beginning of your package
with the above code and set the different property values
for the other objects programatically.

HTH

Cheers,
Sanka





Quote:
-----Original Message-----
Hello,

I have a series of related DTS packages and I want to use
one .ini file to drive all the Dynamic Property tasks for
all of them.

Once I get to approx. 5K in my .ini file, I seem to hit a
size limitation. The Section drop-down list in the
Add/Edit Assignment dialog box truncates one of the
section names that appears near the end of the .ini file,
and doesn't display any section names appearing further
down in the file. If I re-order the section names, the
one
in the same position that was previously truncated is now
truncated, and later section names still don't appear.

Is there a size limitation on the .ini file in a Dynamic
Property task?

Thanks for your help,

Mike van de Vijsel
.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.