Hello all,

I have a DTS package saved to run as a scheduled .bat. There is an ActiveX
script within the package which among other things contains:

oSendMailTask.MessageText = "texttexttext " & vbCrLf & "Uke: "&Datepart("y",
(NOW)/7) & "_" &Year(Now()) [...]

To keep track of changes while working out the whole package, I intentionally
entered a misspelling in the above which by now is corrected. However - when
the mail that is the end result of the DTSrun is composed, my earlier
misspelling is still there! I really do think I've checked everything re.
version GUID (generated by DTSrun UI).

What can be the cause of this? Please help!

Thank you! -
knut


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200509/1

If you are sure you have made the change then you are executing the
wrong version of the package. Get rid of the version info and cut
DTSRUN down to the real basics.

Allan

"Knut B via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

Hello,

Well, to the best of my knowledge, I did that - I ditched all but the most
recent version and regenerated the cmd prompt to run in DTSrun. Still the
same behavior. Only thing I can think of to shed some light is that the
package initially was created as a "Save as..." from another package and that
there's something re: ActiveX tasks I just don't know about. (I also have
GlobalVariables in there.)

I eventually deleted the ActiveX task, then reinstated it with the same code
and got rid of the problem. But it sure was pretty strange.

Thanks for replying anyhow.

knut

Allan Mitchell wrote:

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200509/1