我在新创建的数据库中无法导入数据，一直无法选中，显示版本不正确

English:

Hi @ Century,

 

Thank you for reaching out to the SQL Forum. Based on the screenshots you shared showing the errors, please find below the recommended troubleshooting steps:

 

The system can't find this file or one of its dependencies. This usually happens when:

 

SQL Server Integration Services (SSIS) components are not fully installed There's a version mismatch between the wizard and the installed SSIS libraries The required DLL is missing or corrupted 1.Repair or Reinstall SSIS Components

 

Open SQL Server Installer

 

Choose Modify your SQL Server instance

 

Ensure Integration Services is selected and installed

 

Check for Missing DLL Navigate to: C:\Program Files\Microsoft SQL Server\160\DTS\Binn

 

Look for Microsoft.DataTransformationServices.ScaleHelper.dll

 

If missing, reinstalling SSIS should restore it

 

Run Wizard from Correct Version If you have multiple SQL Server versions installed, make sure you're launching the wizard from the correct version (SQL Server 2022 if you're using v16 assemblies)

 

Apply Latest Updates Run SQL Server Update to ensure all components are patched and compatible

 

To resolve the ConnectionString property has not been initialized error in the SQL Server Import/Export Wizard, start by checking that both your source and destination are properly configuredwhether it's SQL Server, Excel, or a flat file and ensure all connection details are filled in. If you're using a saved .dtsx package or script, open it and confirm that the ConnectionString property is correctly defined with something like Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;. Finally, if the wizard seems to be glitching, simply restart it and re-enter all required fields to ensure a clean session

 

If you're still encountering any challenges, feel free to let us know we'd be glad to assist you further.

 

Looking forward to your response.

 

Best regards,

Lakshmi.

Chinese:

您好 @Century，

 

感谢您联系 SQL 论坛。根据您提供的错误截图，以下是建议的故障排除步骤：

 

系统找不到此文件或其某个依赖项。通常情况下，以下情况会导致此问题：

 

SQL Server Integration Services (SSIS) 组件未完全安装

 

向导与已安装的 SSIS 库版本不匹配

 

所需的 DLL 文件缺失或损坏

 

1. 修复或重新安装 SSIS 组件

 

打开 SQL Server 安装程序

 

选择“修改 SQL Server 实例”

 

确保已选择并安装 Integration Services

 

检查缺失的 DLL 文件

 

导航至：C:\Program Files\Microsoft SQL Server\160\DTS\Binn

 

查找 Microsoft.DataTransformationServices.ScaleHelper.dll

 

如果缺失，重新安装 SSIS 应该可以恢复该文件

 

从正确的版本运行向导

 

如果您安装了多个 SQL Server 版本，请确保从正确的版本启动向导（如果您使用的是 v16 程序集，则应从 SQL Server 2022 启动）

 

应用最新更新

 

运行 SQL Server 更新程序，确保所有组件都已修补并兼容

 

要解决 SQL Server 导入/导出向导中“ConnectionString 属性未初始化”的错误，请启动请检查源和目标是否配置正确（无论是 SQL Server、Excel 还是平面文件），并确保所有连接详细信息都已填写。如果您使用的是已保存的 .dtsx 包或脚本，请打开它并确认 ConnectionString 属性已正确定义，例如 Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;。最后，如果向导出现故障，只需重新启动它并重新输入所有必填字段，以确保会话正常。

 

如果您仍然遇到任何问题，请随时告知我们，我们将竭诚为您提供进一步的帮助。

 

期待您的回复。

 

此致，

 

 

 

 

 

 

Hi Century,

English:

Here’s a step-by-step approach to import the data into the newly created database using the Import Data option with sample data. It’s working as expected on my end. Could you please try the mentioned steps and let us know how it goes? We’ll be happy to assist you further.

Please find the attached documents and let us know how it’s going from your end.

Thanks,

Chinese:

嗨 Century，这是一个逐步的方法，使用“导入数据”选项将数据导入新创建的数据库，并附有示例数据。在我这边测试运行正常。请您尝试上述步骤，并告诉我们进展如何？我们将很乐意进一步协助您。请查收附件文件，并让我们知道您那边的情况。谢谢，

Importdata.pdf