SYMPTOMS
In Microsoft SQL Server 2000, when you use Data Transformation Services (DTS) to create a Dynamic Properties task and you add an .ini file that contains more than 254 characters in section names, the section names are truncated to a total length of 254 characters. Therefore, one of the section names in the
Section list may be truncated, and the remaining section names will not be displayed.
If you try to set the section name to the truncated section name in the
Section list, the following symptoms occur:
- The key name is not displayed in the Key list.
- You receive the following error message when you click OK:
No key name provided.
Additionally, if you set the section name manually in code by using the
SourceIniFileSection property and then try to run the DTS package, you may receive the following error message:
Section 'YourSourceiniFileSection' not found.
For a list of previous hotfixes, see the "Microsoft SQL Server 2000 post-Service Pack 3 or Microsoft SQL Server 2000 post-Service Pack 3a hotfixes" section in the following Microsoft Knowledge Base article:
810185 SQL Server 2000 hotfix update for SQL Server 2000 Service Pack 3 and 3a
back to the topRESOLUTION
Service pack information
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 How to obtain the latest SQL Server 2000 service pack
Hotfix information
Prerequisites
To apply this hotfix, you must have Microsoft SQL Server 2000 Service Pack 3 (SP3) installed on your computer.
For additional information about how to obtain SQL Server 2000 SP3, click the following article number to view the article in the Microsoft Knowledge Base:
290211
How to obtain the latest SQL Server 2000 service pack
back to the topRestart requirement
You do not have to restart your computer after you apply this hotfix.
back to the topFile information
This hotfix contains only those files that are required to correct the issues that this article lists. This hotfix may not contain all the files that you must have to fully update a product to the latest build.
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the
Time Zone tab in the Date and Time tool in Control Panel.SQL Server 2000, 32-bit versions
Date Time Version Size File name
-----------------------------------------------------------------
18-Aug-2004 01:55 2000.80.970.0 664,128 Autoplt.dll
18-Aug-2004 01:55 2000.80.970.0 78,400 Console.exe
18-Aug-2004 01:55 2000.80.970.0 332,352 Ctasksui.dll
18-Aug-2004 01:55 2000.80.970.0 315,968 Custtask.dll
18-Aug-2004 01:55 2000.80.970.0 33,340 Dbmslpcn.dll
08-Apr-2004 21:42 786,432 Distmdl.ldf
08-Apr-2004 21:42 2,359,296 Distmdl.mdf
10-Oct-2003 18:48 180 Drop_repl_hotfix.sql
18-Aug-2004 01:55 2000.80.970.0 1,905,216 Dtspkg.dll
18-Aug-2004 01:55 2000.80.970.0 528,960 Dtspump.dll
18-Aug-2004 01:55 2000.80.970.0 1,557,052 Dtsui.dll
18-Aug-2004 01:55 2000.80.970.0 639,552 Dtswiz.dll
10-Oct-2003 18:48 747,927 Instdist.sql
10-Oct-2003 18:48 1,581 Inst_repl_hotfix.sql
18-Aug-2004 01:55 2000.80.970.0 352,828 Isqlw.exe
18-Aug-2004 01:55 2000.80.970.0 82,492 Itwiz.exe
18-Aug-2004 01:55 2000.80.970.0 90,692 Msgprox.dll
19-May-2004 23:43 8.11.40209.0 209,408 Mssdi98.dll
18-Aug-2004 01:55 2000.80.970.0 62,024 Odsole70.dll
18-Aug-2004 01:56 2000.80.970.0 25,144 Opends60.dll
18-Aug-2004 01:55 2000.80.970.0 57,904 Osql.exe
18-Aug-2004 01:55 2000.80.970.0 279,104 Pfutil80.dll
10-Oct-2003 18:37 550,780 Procsyst.sql
08-Apr-2004 21:42 12,305 Qfe469315.sql
08-Apr-2004 21:42 19,195 Qfe469571.sql
18-Aug-2004 00:26 5,155 Qfe472197.sql
18-Aug-2004 01:55 2000.80.970.0 143,940 Qrdrsvc.exe
18-Aug-2004 02:16 1,105,167 Replmerg.sql
18-Aug-2004 01:55 2000.80.970.0 221,768 Replprov.dll
18-Aug-2004 01:55 2000.80.970.0 307,784 Replrec.dll
18-Aug-2004 00:46 2000.80.970.0 159,813 Replres.rll
18-Aug-2004 00:26 1,086,925 Replsys.sql
10-Oct-2003 18:48 986,603 Repltran.sql
18-Aug-2004 01:55 2000.80.970.0 287,304 Rinitcom.dll
18-Aug-2004 01:55 2000.80.970.0 78,416 Sdiclnt.dll
18-Aug-2004 01:55 2000.80.970.0 66,112 Semmap.dll
18-Aug-2004 01:55 2000.80.970.0 57,916 Semnt.dll
18-Aug-2004 01:55 2000.80.970.0 492,096 Semobj.dll
18-Aug-2004 01:20 2000.80.970.0 172,032 Semobj.rll
18-Aug-2004 01:55 2000.80.970.0 53,832 Snapshot.exe
13-Jul-2004 20:59 117,834 Sp3_serv_uni.sql
18-Aug-2004 01:54 2000.80.970.0 28,672 Sqlagent.dll
18-Aug-2004 01:55 2000.80.970.0 311,872 Sqlagent.exe
18-Aug-2004 01:54 2000.80.970.0 168,001 Sqlakw32.dll
18-Aug-2004 01:55 2000.80.970.0 33,344 Sqlctr80.dll
18-Aug-2004 01:55 2000.80.970.0 4,215,360 Sqldmo.dll
18-Aug-2004 01:55 25,172 Sqldumper.exe
18-Aug-2004 00:35 2000.80.970.0 28,672 Sqlevn70.rll
18-Aug-2004 01:55 2000.80.970.0 156,224 Sqlmaint.exe
18-Aug-2004 01:55 2000.80.970.0 180,792 Sqlmap70.dll
18-Aug-2004 01:55 2000.80.970.0 188,992 Sqlmmc.dll
18-Aug-2004 01:15 2000.80.970.0 479,232 Sqlmmc.rll
18-Aug-2004 01:55 2000.80.970.0 401,984 Sqlqry.dll
18-Aug-2004 01:55 2000.80.970.0 57,920 Sqlrepss.dll
18-Aug-2004 01:55 2000.80.970.0 7,581,777 Sqlservr.exe
18-Aug-2004 01:55 2000.80.970.0 590,396 Sqlsort.dll
18-Aug-2004 01:55 2000.80.970.0 45,644 Sqlvdi.dll
18-Aug-2004 01:55 2000.80.970.0 106,588 Sqsrvres.dll
18-Aug-2004 01:55 2000.80.970.0 33,340 Ssmslpcn.dll
18-Aug-2004 01:55 2000.80.970.0 82,492 Ssnetlib.dll
18-Aug-2004 01:55 2000.80.970.0 25,148 Ssnmpn70.dll
18-Aug-2004 01:55 2000.80.970.0 123,456 Stardds.dll
18-Aug-2004 01:55 2000.80.970.0 158,240 Svrnetcn.dll
18-Aug-2004 01:55 2000.80.970.0 76,416 Svrnetcn.exe
18-Aug-2004 01:55 2000.80.970.0 49,228 Ums.dll
18-Aug-2004 01:55 2000.80.970.0 98,872 Xpweb70.dll
SQL Server 2000, 64-bit versions
Date Time Version Size File name Platform
------------------------------------------------------------------------
18-Aug-2004 09:03 2000.80.970.0 56,832 Dbmslpcn.dll IA64
08-Apr-2004 21:42 786,432 Distmdl.ldf
08-Apr-2004 21:42 2,359,296 Distmdl.mdf
10-Oct-2003 18:48 180 Drop_repl_hotfix.sql
18-Aug-2004 09:01 2000.80.970.0 528,960 Dtspump.dll X86
10-Oct-2003 18:48 747,927 Instdist.sql
10-Oct-2003 18:48 1,581 Inst_repl_hotfix.sql
18-Aug-2004 09:03 2000.80.970.0 185,856 Msgprox.dll IA64
19-May-2004 23:43 8.11.40517.0 722,944 Mssdi98.dll IA64
18-Aug-2004 09:03 2000.80.970.0 150,528 Odsole70.dll IA64
18-Aug-2004 09:03 2000.80.970.0 27,136 Opends60.dll IA64
18-Aug-2004 09:02 2000.80.970.0 148,992 Osql.exe IA64
10-Oct-2003 18:37 550,780 Procsyst.sql
08-Apr-2004 21:42 12,305 Qfe469315.sql
08-Apr-2004 21:42 19,195 Qfe469571.sql
18-Aug-2004 00:26 5,155 Qfe472197.sql
18-Aug-2004 09:02 2000.80.970.0 352,768 Qrdrsvc.exe IA64
18-Aug-2004 02:16 1,105,167 Replmerg.sql
18-Aug-2004 09:03 2000.80.970.0 534,016 Replprov.dll IA64
18-Aug-2004 09:03 2000.80.970.0 769,536 Replrec.dll IA64
18-Aug-2004 02:19 2000.80.970.0 146,432 Replres.rll
18-Aug-2004 00:26 1,086,925 Replsys.sql
10-Oct-2003 18:48 986,603 Repltran.sql
18-Aug-2004 09:03 2000.80.970.0 650,240 Rinitcom.dll IA64
18-Aug-2004 09:03 2000.80.970.0 160,768 Semmap.dll IA64
18-Aug-2004 09:03 2000.80.970.0 132,608 Semnt.dll IA64
18-Aug-2004 09:02 2000.80.970.0 89,088 Snapshot.exe IA64
13-Jul-2004 20:59 117,834 Sp3_serv_uni.sql
18-Aug-2004 09:01 2000.80.970.0 10,240 Sqlagent.dll IA64
18-Aug-2004 09:02 2000.80.970.0 1,055,232 Sqlagent.exe IA64
18-Aug-2004 09:03 2000.80.970.0 32,256 Sqlctr80.dll IA64
18-Aug-2004 09:03 2000.80.970.0 13,845,504 Sqldmo.dll IA64
18-Aug-2004 09:02 39,936 Sqldumper.exe IA64
18-Aug-2004 02:04 2000.80.970.0 19,968 Sqlevn70.rll
18-Aug-2004 09:02 2000.80.970.0 493,568 Sqlmaint.exe IA64
18-Aug-2004 09:03 2000.80.970.0 23,040 Sqlmap70.dll IA64
18-Aug-2004 09:03 2000.80.970.0 152,064 Sqlrepss.dll IA64
18-Aug-2004 09:03 2000.80.970.0 24,979,456 Sqlservr.exe IA64
18-Aug-2004 09:03 2000.80.970.0 616,960 Sqlsort.dll IA64
18-Aug-2004 09:03 2000.80.970.0 120,320 Sqlvdi.dll IA64
18-Aug-2004 09:03 2000.80.970.0 227,328 Sqsrvres.dll IA64
18-Aug-2004 09:03 2000.80.970.0 53,760 Ssmslpcn.dll IA64
18-Aug-2004 09:03 2000.80.970.0 254,976 Ssnetlib.dll IA64
18-Aug-2004 09:03 2000.80.970.0 20,992 Ssnmpn70.dll IA64
18-Aug-2004 09:03 2000.80.970.0 430,080 Svrnetcn.dll IA64
18-Aug-2004 09:02 2000.80.970.0 185,856 Svrnetcn.exe IA64
18-Aug-2004 09:03 2000.80.970.0 187,392 Xpweb70.dll IA64
Note Because of file dependencies, the most recent hotfix that contains these files may also contain additional files.
back to the top