因?yàn)樽鰷y(cè)試在一臺(tái)windows server 2003的機(jī)器上安裝了一套biztalk 2004（也可能不是由于裝了這個(gè)導(dǎo)致的），突然發(fā)覺(jué)沒(méi)有辦法在enterprise manager里面導(dǎo)入、導(dǎo)出數(shù)據(jù)。查了一下微軟支持網(wǎng)站沒(méi)有任何想法，于是老辦法google了一下，居然發(fā)現(xiàn)這樣一篇小文章，跟各位分享：
this can happen after some additional software has been installed, and dlls required by dts have been overwritten. the main culprit is comcat.dll (winnt ystem32). version 4.71 is required for dts to function correctly. for a quick fix copy comcat.dll from your sql 7 cd-rom, and register it as described below. if this does not work then start working your way through the suggestions below. (re-)apply sp1 or sp2 (re-)install internet explorer 5 copy comcat.dll from the sql 7 cd-rom to /winnt ystem32, replacing the existing version. re-register comcat.dll [regsvr32 /winnt ystem32/comcat.dll] re-register the dts dlls regsvr32 /mssql7/binn/axscphst.dll (sql server 2000: /microsoft sql server/80/tools/binn/axscphst.dll) regsvr32 /mssql7/binn/dtsffile.dll (sql server 2000: /microsoft sql server/80/tools/binn/dtsffile.dll) regsvr32 /mssql7/binn/dtspkg.dll (sql server 2000: /microsoft sql server/80/tools/binn/dtspkg.dll) regsvr32 /mssql7/binn/dtspump.dll (sql server 2000: /microsoft sql server/80/tools/binn/dtspump.dll) regsvr32 /mssql7/binn/dtsui.dll (sql server 2000: /microsoft sql server/80/tools/binn/dtsui.dll)
