Posts
10
Comments
14
Trackbacks
0
DTS Logging - SQL Server 2000

It’s been a while since I used DTS.  I was trying to remember the right way to do logging in DTS.  First, I just said - hey, I’ll do a File System Object File.  Then, I said to myself, no way, that’s bogus, there has got to be an easier way……  So I found this:DTSPackageLog.  What’s funny is that the DTSPackageLog may or may not be available.  You have to test it for null or nothing prior to attempting to use it.  I soo hate that crap.  It makes no sense to me.  I used to feel bad about not understanding these sorts of ideas, until a good friend told me to take it easy on myself.  I think what he said was - “It’s not you, it just doesn’t make sense.”   Long story short, DTSPackageLog = sounds neat, but long term plan = fso writing to a reliable ( existing ) temp folder.

http://msdn2.microsoft.com/en-US/library/aa936769(SQL.80).aspx

http://www.ureader.com/message/1200664.aspx

posted on Monday, February 25, 2008 12:54 PM Print
Comments have been closed on this topic.
News