I have a simple SSIS package with a data flow task with ADO.NET source & destination:
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?
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.
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.
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)
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With