ms sql ssis为优势数据库服务器映射xml

时间:2022-10-28 23:55:13

I want to use the sql server-import/export assistent to import data from an advantage databaser server to ms sql server. I can connect to the advantage databaser using the ole db driver but I have problems with the datatype mapping. We have several nchar-fields in different tables and they are all shown as data-type "130". I can edit them manually to nchar, but as there are hundreds of fields it would be nice if it is possible to create a mapping-xml manually for this problem.

我想使用sql server-import / export assistent将数据从优势数据库服务器导入到ms sql server。我可以使用ole db驱动程序连接到advantage数据库,但是我遇到了数据类型映射的问题。我们在不同的表中有几个nchar-fields,它们都显示为数据类型“130”。我可以手动编辑它们到nchar,但由于有数百个字段,如果可以手动为此问题创建mapping-xml,那将是很好的。

Did anyone had the same problem before and created a mapping file manually? I do not know how to name it.

之前是否有人遇到过相同的问题并手动创建了映射文件?我不知道如何命名。

Any help would be great!

任何帮助都会很棒!

Maggi

1 个解决方案

#1


0  

I solved my problem by adding the table structure to the ms-sql database using a sql-script and the connect the import to that existing database. The import-assistent then will automatically find the correct field-types and the import works without problems.

我通过使用sql脚本将表结构添加到ms-sql数据库并将导入连接到现有数据库来解决了我的问题。然后,import-assistent将自动找到正确的字段类型,导入工作没有问题。

Regards Maggi

#1


0  

I solved my problem by adding the table structure to the ms-sql database using a sql-script and the connect the import to that existing database. The import-assistent then will automatically find the correct field-types and the import works without problems.

我通过使用sql脚本将表结构添加到ms-sql数据库并将导入连接到现有数据库来解决了我的问题。然后,import-assistent将自动找到正确的字段类型,导入工作没有问题。

Regards Maggi