March 25, 2009 at 7:54 pm
Hello All,
Actual Work of my package: in my SSis package what i am doing is from loading DB from one db to another (so i have source connection, destination connection and some file connection in my connection manager)
i have a send mail task in my events (when package fails, it send a mail) it is working fine.
but now the problem is when ever it is unable to connect to source DB (such as Source connection manager DB is unable to connect ) then it is not throwing any error
how can i make my package, that returns even this kind of fail overs
please help me, Thanks in adavnce
Best Regards
asita
March 25, 2009 at 7:59 pm
What do you have in the Event handler? I would've thought that the on error event would fire if the connection did not exist/not found/whatever?
March 25, 2009 at 8:23 pm
Yes i have send mail task in On Error event of package,
but it didn't
Does it surely work even it fails source connection or any type error?
Best Regards
asini
March 25, 2009 at 8:44 pm
Sorry - I don't know the answer to that - perhaps someone else on here can help?
March 26, 2009 at 10:48 am
Hi Asita,
In many of my packages, I have used Send Mail Task.
I had referred to this website for setting the Send Mail Task;
http://agilebi.com/cs/blogs/jwelch/archive/2007/05/05/handling-multiple-errors-in-ssis.aspx
Now, I never had any connection issues till now, so I do not know exactly if it send error messages for connection managers too. But I can tell you one thing that after reading your post, I just tried to delete a connection manager and run the package. The package did not even run. It errored out mentioning that the connection manager specified is not found. Which means, that if you are trying to run / execute the package from BIDS by itself, then it will not send you an email for connection managers.
But I am not sure about what will happen if you run the package as a job.
I guess, you should try to set up a job with a package that has one connection manager missing and then try to run that job. If the job runs and if you get an error message, then it is good. But if the job runs but still you do not get an error message, means that the send mail task is not sending emails for all errors except connection managers.
Do let me know if you figure this out.
Good question!
Good Luck!
March 26, 2009 at 4:59 pm
Hello Notes,
thank you very much for your reply,
i will go through it, mean while i was stucked with some urgent Quaretr end stuff
any way i will let you know once i finish it
Thanks also see this below blog (suggested by RafailSalss)
it has good one tooo
Best Regards
asit
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy