This will be a long post, but it is a complicated problem.
Situation: We have 3 databases involved. Progress is the production database. SQL Server is the data warehouse. Oracle houses the combined financial data between Progress (via the data warehouse) and our other Oracle databases.
Problem:
1. Data is imported successfully into SQL Server from Progress using a SQL script written by an INFOR technician
Example:
IF object_id('insite..wi_icseg') IS NOT NULL
DROP TABLE insite..wi_icseg;
SELECT
*INTO insite..wi_icseg
FROM
OPENQUERY(TRAIN, 'SELECT a.* FROM PUB.icseg)
2. The column names are created in lower case, like the Progress table.
3. The table is recreated every day.
4. The data in this table gets exported to Oracle from SQL Server 2005 every day.
5. Oracle maintains the case of the column names.
6. Oracle defaults to uppercase in all table and column names, therefore SQL references must use quotes or it is not found.
7. This creates a giant problem with existing scripts and programming efforts due to the inconsistency.
Avenues tried so far:
1. Created the SQL Server table with column names in caps. Truncated table instead of dropping table. This works great.
2. The INSERT INTO command does not seem to work with OPENQUERY. The documentation says it should work, but I get a syntax error at or near OPENQUERY. I have been unable to find any examples of these two commands put together. I need the statement that will allow me to insert data from an outside source into an existing SQL Server 2005 table. The truncate works fine. A SELECT * INTO does not work because the table already exists.
Any advice would be helpful. I will clarify anything that may be fuzzy. Our go live date for the entire project is August 1st and we need this resolved before we switch systems. Thanks so much in advance for any help.

Data transfer between Progress-SQL Server 2005-Oracle