dbTalk Databases Forums  

[Re:] .ini file size limitations in Dynamic Properties Task

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


Discuss [Re:] .ini file size limitations in Dynamic Properties Task in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Russ Perry Jr
 
Posts: n/a

Default [Re:] .ini file size limitations in Dynamic Properties Task - 11-12-2004 , 12:55 PM






[sorry no threading; Google Groups doesn't let you respond to
old posts? This post was from 2004-09-27 23:28:26 PST]

Ankur (shuklaankur (AT) hotmail (DOT) com) wrote:
Quote:
We have a series of related DTS packages and We want to use
one .ini file to drive all the Dynamic Property tasks for
all of them.
We're doing something very similar here.

Quote:
Once We get to approx. 6KB in the .ini file, We 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.
There are a variety of limits, it would appear. Another one I
found while searching was the line length -- I'd discovered that
one myself, but didn't experiment to see how long a line was
allowed.

I also found a variation on yours... I chose a Section, but when
I tried to choose a Key, I ran into the same situation that you
note -- one was cut off, and the rest missing. The interesting
thing was that if I split that Section into two, it was all better.
In other words, there's just a limit on how many Keys you can put
in one Section. I suspect what you ran into was more like that
(a limit on how many Sections can be in one INI) rather than a
strict file-size limitation, but that's guessing.

Does anyone have all the limits of INI files in DTS documented?


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.