SSIS Oracle RDB to 10G source

Lessons for me from this exercise:

• I had to throw away the custom ODBC script tasks I had built for RDB and create a new OLE DB based extraction package
• Data that previously loaded into SQL Server Int columns now caused a datatype mismatch error. I had to change the target columns to Numeric
• This had the flow-on effect of causing many data flow data sources to break with an invalid index error. These data sources had to be recreated
• Some text data that had previously loaded in a trimmed state now had trailing spaces

So that was the dev environment. To get the packages to work via IIS required:

• Had to allow inprocess in SQL Management Studio for the provider OraOLEDB.Oracle http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=766133&SiteID=1
• Working my way through the steps in http://support.microsoft.com/kb/255084. The reboot actually made a difference