ODBC-based to OLE DB-based data transfer

I would like to transfer selected data from an ODBC-based table to a OLEDB-based table. However, there isn't a data flow source on the Data Flow Design screen to accomodate such an action. Please help!

Roberto,

You need to create a package with a DataFlow task in it; then inside of the DataFlow; then from the toolbox you can use a Data Reader component to use an ODBC connection. Additionally you will need to add any data transformation logic/tasks and an OLE DB destination component.

There is not such 'all-in-one' task to perform what you want; but you have many components that you can combine together to get it

Rafael Salas