Ora source table receives continuous transaction
I have a oracle source table in my ETL which is getting loaded 24/7 continuously, when I run the data load from this table to SQL server using SSIS ETL with table fast load. My package loads some data and it fails. If I stop the oracle source table from getting continuously loaded, my ETL pkg runs fine, I see this in dev env. But in real time on prod I cannot do this, why can’t my pkg load and run with out failing.
One more thing, I have SQL server target table, I pick up the max of last inserted data in SSIS variable and use it for querying incremental load from source oracle table.
Table lock and check constraint in destination(SQL Server) oledb are ticked
I have a oracle source table in my ETL which is getting loaded 24/7 continuously, when I run the data load from this table to SQL server using SSIS ETL with table fast load. My package loads some data and it fails. If I stop the oracle source table from getting continuously loaded, my ETL pkg runs fine, I see this in dev env. But in real time on prod I cannot do this, why can’t my pkg load and run with out failing. One more thing, I have SQL server target table, I pick up the max of last inserted data in SSIS variable and use it for querying incremental load from source oracle table. Table lock and check constraint in destination(SQL Server) oledb are ticked Read More
