sql server dts: Hi,
I'm trying to find a way to execute a package remotely and then to
notify the users that the execution is over.

I created a SQL Agent job I'm starting thru a SP call.
The problem is that the execution is asynchronous.
How could I notify the user that the execution of the package is over?
Notification Services? Other?

Thanks,

Olivier

Hello,

I may be mis-understanding your question.
Rather than get notification services involved, can you not just add a 'send
mail' task to your SSIS package that will send an SMTP email to interested
users?

[quoted text, click to view]

Well, the point is that the package execution is a part of a process
launched from a client app (vb6 so far).
The application is thus starting the package and waiting for it to
display some results. I have thus to find a way to get synchronized.

Olivier.

Hello oliviers,

It will be the packages job to tell you then that it is done. Either log
to a table the fact that you are done or maybe use the Send Mail task to
end someone a mail.

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]