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!

Fail Package on first error flag

Status
Not open for further replies.
collierd

collierd

MIS
Dec 19, 2001
509
DE
Hello

I am using SQL 2000

Does anybody know what table/field holds the Fail Package on first error flag within a DTS package
I have about 75 packages to amend and it's going take some time so I can act on failures

Thanks

Damian.
 
Sort by date Sort by votes
DTS packages are stored in the msdb database. Unfornitually they are storred i binary, so there isn't much you can do to automatically update them via T/SQL.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

[noevil]
(Not quite so old any more.)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arodri
  • Locked
  • Question
MSVisual Studio - DTSX Package creating new text file
Replies
0
Views
158
arodri
arodri
HoustonGuy
  • Locked
  • Question
CPU usage of a package using tables on another server
Replies
0
Views
60
HoustonGuy
HoustonGuy
ashleybyrdnc
  • Locked
  • Question
DTS Package Failing
Replies
1
Views
82
mrdenny
mrdenny
collierd2
  • Locked
  • Question
Changing the data source/destination of a package
Replies
1
Views
68
rac2
rac2
kat50
  • Locked
  • Question
How to import a txt file based on position
Replies
0
Views
190
kat50
kat50

Part and Inventory Search

Sponsor

Back
Top