Hello
I have a SSIS package that copies data from one database to another. If I have an active connection running on my target database the package fails.
Is this an error caused by the design of SSIS or is it possible for me to drop all active connections on source and target database when the SSIS package runs?
Thank you.
I have a SSIS package that copies data from one database to another. If I have an active connection running on my target database the package fails.
Is this an error caused by the design of SSIS or is it possible for me to drop all active connections on source and target database when the SSIS package runs?
Thank you.