sql server dts: Problem with version of DTS package -- sql server dts

Problem with version of DTS package

Knut B via SQLMonster.com
9/7/2005 12:22:03 PM

sql server dts: 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

Re: Problem with version of DTS package

Allan Mitchell
9/7/2005 6:39:04 PM

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

[quoted text, click to view]

Re: Problem with version of DTS package

Knut B via SQLMonster.com
9/7/2005 8:01:05 PM

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

[quoted text, click to view]

--
Message posted via SQLMonster.com

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.