I am trying to import from an Excel spreadsheet or an Access database into an Oracle table. I used the SSIS Import and Export wizard to create the SSIS packages, but everytime that I attempt to run the package, SSIS stops once it gets to the Pre-Execute
phase. There are never any errors. Am I doing something that cannot be done?
I'm using the following: SSIS 2005, Microsoft Oracle OLEDB provider (MSDAORA.1), Excel and Access 2003
By the way, I am able to successfully export from the Oracle database to either Excel or Access using SSIS.
View Complete Post