Cursor from hell project #3.
Lets take oracle data into a SQL Server DW in raw format. Now lets take the tables and add columns for the lookups.
I am using 4 SP's to do this. First creates a Cursor for all the different apps we have in Oracle (Services). This calls #2 whick takes the meta data for the tables and blows away the existing table from yesterday and re-creates it today. #3 does the table creation. #4 makes the script to poplulate the new table
.
Problem is in #3.
I loose the logging of print lines to the Messages, and it appears like the batch is stuck. Yet I get more data tables created. Anybody know something about this?