ssis OLEDB Source connection manager

Asked Jul 27 '15 at 17:17

Active Jul 27 '15 at 17:49

Viewed 31 times

My source Database is getting restored every 15 mins. When I tried to load the data from source DB, it is kicking me out, hence my package is failing. Is there anyway in SSIS to wait for source DB connection to come back and start the extraction without failing the package? Because my source DB has 180 million data and I need to extract from there.

I am using SSIS 2008

Thanks a lot in advance!

edited Jul 27 '15 at 17:49

Chris Albert

2,462
8
27
31

asked Jul 27 '15 at 17:17

mls1984

1

Why not have the restore job kick off this ssis package when it is done? – Chris Albert Jul 27 '15 at 17:23
Try changing the isolation level of the package. Maybe "Snapshot" would work. – Tab Alleman Jul 29 '15 at 17:33

ssis OLEDB Source connection manager

0 Answers0