Is there any way around (or will there be) using the drop-down? It takes several minutes when running against an Oracle Apps database to populate that dropdown with the several hundreds of tables and views.
TIA.
Yes, just write a SQL statement instead. You should be doing this anyway to be honest, selecting from the dropdown is very bad practice.
-Jamie
|||
For an OLE DB Destination? I always write SQL for the sources, but don't quite follow how to do that for a destination.
Thanks for the quick reply!
-Chad
|||DAMN. You said Destination. Sorry, I should read posts more clearly.
However, you can still do this. Just select 'SQL Command' as your Data Access Mode and your SQL statement just selects all the columns that you want to insert into from the table that you want to insert into.
Ignore what I said about best practice though. its best practice for sources, not destinations.
-Jamie
No comments:
Post a Comment