SSIS OLEDB destination with SQL command

sql sql-server-2008 ssis oledb
PoeHaH picture PoeHaH · Jun 17, 2013 · Viewed 19.4k times · Source

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

Answer

Maximus picture Maximus · Jun 17, 2013

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.

Related questions

Select Query for the fixed length

I have an table called customer where i am selecting few columns and making its fixed length,where i need to send the values to SSIS packages for an fixed length output and is written in a text file customerID:10 …

Read More
SSIS Count of Object Variable?

I am using SSIS in BIDS 2008 and I am trying to get a count of an Object Variable containing a list of files. Any idea on how to do this? Thanks!

Read More
How can I convert "SQL_Latin1_ General" Collate Using an SSIS Package?

We've just noticed 2 of our servers have been set up using SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS. I've created a script which compares two sources of data again each other (as it's a simple SELECT …

Read More