In My ssis package:
1: Execute sql task has : select * into tableA from tableSource, usuallay it will copy around 5 millions of rows
: delete from tableA for certain unwated records
3:Insert data to actual table:
My problem is that when sometimes this package run, it not completely copy all the rows, for eg: it should copy all data until 23:59:59.000 but for soem reasons it just copy until 23:04 or sometime 23:30 and so on..
why this can happen ? i