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