C # solution to DTS package error when the program does not install SQL2000 [arrangement]

Error description:

Error message: clsid {10020202-eb1c-11cf-ae6e-00aa004a34d5}

ErrorCodeIs: (0x80040154)

 

Solution:

1. Install the SQL2000 client on the machine (solved)

2. Copy all the components required by the DTS package to the target machine for registration (this method has been tried and failed)

3. Install msde2000 (a convenient solution)

A. This file can be downloaded here: http://www.microsoft.com/downloads/details.aspx? Displaylang = ZH-CN & familyid = 413744d1-a0bc-479f-bafa-e4b278eb9147

B. if you have an office installation Program , this file will also exist in the Office installation CD or the root directory of the independent installation folder (I installed office2003, and I have not tried other versions of office), there is a msde2000 folder, there is a file named msde2ks3. EXE, open it and decompress it to a directory. The directory is usually the default one. After decompression, find setup in that directory. INI file. If you only see [ options ]. Add the following two lines of text:

Securitymode = SQL
Sapwd = Admin

// Admin is the password and can be changed to another one

 

Otherwise, an error may occur:"A strong SA password is required for security purposes. Use the sapwd switch to provide the same password. For more information, see the README file. The installer will exit immediately ."

Save the two directories, and then open the setup.exe file in the directory for installation. After installation, you can call the DTS package.

PS: This directory is also available in the SQL2000 installation package.