Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSIS package fails copying database because of active connections

Status
Not open for further replies.
jensjuul

jensjuul

Programmer
Jul 28, 2007
50
DK
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.
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
SSIS in SQL Server 2022
Replies
4
Views
346
grnzbra
grnzbra
grnzbra
  • Locked
  • Question
Editing Mappings Data Types in SSIS
Replies
0
Views
196
grnzbra
grnzbra
TomaszB12
  • Locked
  • Question
Problem with package execution
Replies
1
Views
233
mark williams
mark williams
minhtran360
  • Locked
  • Question
Where do I look for my SSIS pasckage that just being deployed to my sql server?
Replies
1
Views
605
mark williams
mark williams
Igelchen
  • Locked
  • Question
SSIS System.Text.JSON
Replies
0
Views
271
Igelchen
Igelchen

Part and Inventory Search

Sponsor

Back
Top