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!

write log entries to db

Status
Not open for further replies.
OhioSteve

OhioSteve

MIS
Mar 12, 2002
1,352
US
I know how to create a log file in a package's properties. Can I write that stuff to fields in a table? If so, how do I do that.
 
Sort by date Sort by votes
The data from the DTS Logging is in the msdb.dbo.sysdtspackagelog table.

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
I browsed that table and it seems to just record packages executed by the administrator.

That reminds me of another question. Where could I get a list of all of the systables and descriptions of them?
 
Upvote 0 Downvote
Books online has all the system tables, and what they are.

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

botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
151
botatun
botatun
ciarra41
  • Locked
  • Question
Rollup to one record with same order number
Replies
2
Views
175
drlex
drlex
okcorral
  • Locked
  • Question
insert in to DB2 Z/vse via SQL 2005 linked server
Replies
1
Views
172
okcorral
okcorral
Lost500
  • Locked
  • Question
Upsizing access 2007 db to SQL 2005: ODBC connection failed
Replies
1
Views
58
bburnell
bburnell
smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
288
markjoseph1232
markjoseph1232

Part and Inventory Search

Sponsor

Back
Top