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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Fail DTS if unable to connect to database

Status
Not open for further replies.
dollarbill

dollarbill

Programmer
Aug 30, 2002
13
US
Is there a way to fail the entire DTS package based on whether or not a connection to another Database is established? We have had issues with the job still executing even if the server with the database is down. Any info would be appreciated. thanks!
 
Status
Not open for further replies.

Similar threads

Fsoumia
  • Locked
  • Question
DTS Logging
Replies
2
Views
159
Fsoumia
Fsoumia
betachristopher
  • Locked
  • Question
Use IF/ELSE in Query 1
Replies
3
Views
173
drlex
drlex
Azzuri
  • Locked
  • Question
DTS To SQL Server 2008
Replies
1
Views
105
mrdenny
mrdenny
mutley1
  • Locked
  • Question
XLSX import to DTS (SQL 2000)
Replies
0
Views
74
mutley1
mutley1
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
147
botatun
botatun

Part and Inventory Search

Sponsor

Back
Top