Hi.  I know there is no easy way to do fastload through SSIS to an Oracle destination, so I have rearchitected the feedback portion of my ETL (99.9% from Oracle to SQL Server 2005, just a little feeding back to Oracle to allow server side filtering) so that there is just one place where it happens and it doesn't happen often.  However, it still takes a good 20-30 minutes to load 3,048 rows here and that's ridiculous.  In future releases I may not have the happy option of reducing the frequency of feedback needed for filtering and I might need to figure out a way to do bulk loading.

I know you can bulk load to Oracle through a text file but I don't know if it works in SSIS, and besides it would be really inelegant with scripts and strange configs and such, and possibly there would be security issues.  Does anyone out there have a better solution to this problem?  I understand that Microsoft wants to limit Oracle destinations for their ETLs to do a little market arm-twisting.  Is there a custom destination control out there that can be loaded into the SSIS Toolkit?

Thanks.