Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSIS OLEDB destination with SQL command

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

enter image description here

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.

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

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

like image 852
PoeHaH Avatar asked Jun 17 '13 09:06

PoeHaH


People also ask

How use OLE DB destination in SQL?

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. @PoeHaH the SELECT command in this case is not to retrieve data but to retrieve columns metadata from the query result.

What is OLE DB Destination in SSIS?

An OLE DB destination includes mappings between input columns and columns in the destination data source. You do not have to map input columns to all destination columns, but depending on the properties of the destination columns, errors can occur if no input columns are mapped to the destination columns.

What is the difference between SQL Server destination and OLE DB destination in SSIS?

SQL Server Destination requires that ETL server and a destination server are the same (not always preferred) OLE DB Destination allows performance optimization by calibrating batch and max commit size. OLE DB Destination allows developers to choose from several data access modes (BULK INSERT is not always needed)


1 Answers

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.

like image 110
Maximus Avatar answered Sep 30 '22 01:09

Maximus