sql server dts: .ini file size limitations in Dynamic Properties Task -- sql server dts

.ini file size limitations in Dynamic Properties Task

shuklaankur NO[at]SPAM hotmail.com
9/27/2004 11:28:25 PM

sql server dts:

Hello,
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.

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. If We 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.

While going through the microsoft.public.sqlserver.dts group

we found out the following suggestion

"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."

Re: .ini file size limitations in Dynamic Properties Task

Allan Mitchell
9/28/2004 7:41:09 PM

If I have a lot of parameters that I need to set personally I use an alias
to a Server (cliconfg) and store details in a table on that server/database.
This makes it really easy to move stuff round.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

[quoted text, click to view]