"SqlGuy" <homeNONO@gregNOscottNO.COM> wrote in message
news:M9r6d.3774$ls6.2642@newsread3.news.atl.earthlink.net...
> I've got a problem with the logging feature on DTS scripts.
> Each task in the log is identified with some sort of generic prefix, and
> then a very discriptive suffix: _1, _2, _3 or other such "meaningless"
> sufix I have no way to correlate with the specific task. (Why isn't this
> attribute shown it the task properties so it can be modified to a more
> meaningful value??!!)
>
> Anyway, I've decided that perhaps that's the last straw, and I'll actually
> have to learn VB Script, and really get into this stuff.
> If I save the DTS task as a basic file, I assume that I will be able to go
> in, and decipher the mess, and perhaps discover how to write my own, more
> meaningful scripts, perhaps with a script generator, since many tasks are
> very repetitive, and base on column and table names available in the SQL
> database dictionary.
>
> Is there a book on the DTS VBScript language, specificly, or a more
> general one that covers DTS in enough detail to help me navigate this new
> territory? I'm NOT a VB literate guy. I know some really "slick" (or sick,
> depending on your ideas about coding) sql techniques, and have
> considerable DTS experience, but my DTS experience is more repetitive and
> "shallow" than broad. I make it dance and sing, but not necesssarily on
> key, or in time with the beat.
>
> Can you give any tips on the specific issue of associating logged task
> messages with the identity of the task? Thanks.