使用SQL命令的SSIS OLEDB目标 [英] SSIS OLEDB destination with SQL command

问题描述

我有一个简单的SSIS包，带有ADO.NET源&数据流的数据流任务.目的地:

I have a simple SSIS package with a data flow task with ADO.NET source & destination:

通常，我只会在OLEDB目标上选择表或视图"，但是尽管连接正确，但不会显示任何表名.

Normally, I would just select 'table or view' on the OLEDB destination, but although the connection is correct it's not showing me any table names.

所以:我必须使用SQL命令在OLE DB目标中插入行.该目标是一个DB2数据库.

So: I have to use SQL command to insert rows in the OLE DB destination. That destination is a DB2 database.

我的问题:如何编写此sql语句以将ANO NET源中的所有内容插入目标表中?

My question: how can I write this sql statement to insert everything from the ANO NET source into the destination table?

推荐答案

在SQL命令文本中，只需编写

In the SQL Command Text, Just write

SELECT * FROM TableName --Here tablename is the destination table name.

如果尚未映射，请转到映射"并映射适当的列.

And go to the Mapping and map the appropriate columns if it is not already mapped.

这篇关于使用SQL命令的SSIS OLEDB目标的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！