My SSIS package is very slow only for past 2 weeks. Before it used to run in 2 hrs now it is running in 8 hrs. Today the package completely failed with error ": Could not allocate a new page for database 'Test' because of insufficient disk space in filegroup 'PRIMARY' ". Can PRIMARY memory allocation be a reason for the package becoming slow?
Need your opinion to know if I increase the PRIMARY memory space will this issue will be resolved. Most importantly I would like to know will it be a permanent fix.
Please suggest what are the parameters I should consider in the SSIS package and in the source(Oracle) and destination(MS SQL server) to give a permanent fix.
Oracle is 9i and SQL server 2008R2. Data pull is from 5 tables each with 300,000 rows and 10 columns.