Hi to everyone!
It's my first mission in DTS.
I fill global variables with e-mail addresses (maybe with empty string)
of my accounts.
If I have an e-mail(not empty), I need to create an excel file with
data to this account and send messages to him.
I can do it to some alone account, but I have a problem with looping
I saw an example from http://www.sqldts.com/Default.aspx?246
it helped me very much, but when I run it in the loop it dos not
working!
I think a problem in :
stpEnterLoop.DisableStep = False
stpFinished.DisableStep = True
stpEnterLoop.ExecutionStatus = DTSStepExecStat_Waiting
or I do something wrong.
I have 5 ActiveX task. First - fill global variables.
Second starting a loop. Maybe the problem is that i call a second
ActiveX task from itselfe?
Help me please.
Thanks a lot!It's hard to say something without seeing the code (with dts always is the
same) but first of all I'd put a log for that DTS and I'll try to see what
happen.
--
Current location: Alicante (ES)
"Dima" wrote:
> Hi to everyone!
> It's my first mission in DTS.
> I fill global variables with e-mail addresses (maybe with empty string)
> of my accounts.
> If I have an e-mail(not empty), I need to create an excel file with
> data to this account and send messages to him.
> I can do it to some alone account, but I have a problem with looping
> I saw an example from http://www.sqldts.com/Default.aspx?246
> it helped me very much, but when I run it in the loop it dos not
> working!
> I think a problem in :
> stpEnterLoop.DisableStep = False
> stpFinished.DisableStep = True
> stpEnterLoop.ExecutionStatus = DTSStepExecStat_Waiting
> or I do something wrong.
> I have 5 ActiveX task. First - fill global variables.
> Second starting a loop. Maybe the problem is that i call a second
> ActiveX task from itselfe?
> Help me please.
> Thanks a lot!
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment