SQL Server数据库与IBM AS400之间的SSIS数据集成

Is there a way to insert data into an AS/400 library table from a SQL Server database with SSIS 2008r2? We did a test and we can see the tables in the library, but it gives an error when you click on "mappings", see image.

有没有办法使用SSIS 2008r2从SQL Server数据库将数据插入AS / 400库表?我们做了一个测试,我们可以看到库中的表,但是当你点击“映射”时会出现错误,请参见图像。

If we put Journalling on in the AS/400 system the columns are showing and I can make mappings. But this option is creating a lot of extra (logging) space on the AS/400 system, that we don't have or want.

如果我们将Journalling放在AS / 400系统中,那么列就会显示,我可以进行映射。但是这个选项在AS / 400系统上创建了很多额外的(日志记录)空间,这是我们没有或想要的。

Is there a way to get this work without using the Journaling option?

有没有办法在不使用日记选项的情况下完成这项工作?

1 个解决方案

#1

The solution is to change the "data access mode" to a "SQL command".

解决方案是将“数据访问模式”更改为“SQL命令”。

Fill in by the SQL command text the following:

通过SQL命令文本填写以下内容:

SELECT COLUMN_A AS COLUMN_A, 
       COLUMN_B AS COLUMN_B
FROM TABLE

And now you can access the mappings of the table in the AS/400 system/library

现在,您可以访问AS / 400系统/库中表的映射

#1