Send Successor Attachment with airSlate SignNow

Send successor attachment

welcome to tech breville Sudama today we are going to learn how to send an email from SSIS packager so why we need to send an email first of all because if we are running a lot of packages the packages can fail or they can complete sometimes they can take whole lot of time to complete so you want to know okay if the package fail what was the error and what was at a description and you can send that email to the DBA team or protections for team and they can take a look right away and inform the people who can go into the sequel server and fix those issues and rerun the jobs or certain part if on the successor you have loaded a lot of records it's good idea maybe you want to send a summary of the load you want to sender email with the insert record update the record the lead records so the people would know that how many records we got from the source how many loaded how many rejected and all those kind of information they are really helpful so coming back to the options are what we have in the SSI yes sir there are multiple options or we have let me tell you that's what we are going to discuss in the number one what options we have second we are going to learn the send mail task in the SSI yes sir package so let me take you to SSgt sequel server data tools so if you are using old version you will be using bit sir and that's fine we have the same options here so first of all we can use a execute sequel task we can use SP underscore DB send mayor and the desk or procedure can be used to send a simple email HTML email with attachments and all those kind of things though next we have a skip tasks skip tasks whatever we can't do in the built-in tasks we can use the script asked to do that in this case if we need to send an email we can always write C short code or VB code and we can use the script s to perform that action for us in this case let's say we want to send an well formatted HTML email so script ask is our second option we can use it if you don't want to use the execute sequel task and the last one we have a send mail task them that's the built-in task we can use it to send the emails this does not provide the capability to send a HTML formatted emails and the death I think so that's fine because if you want to send an email coming from the SSI use package may be successful email every email some attachment and all those kind of thing this is fine we all do the business and in the business so you don't want to get those different colors and you know pictures and all you don't really use these kind of options when you are dealing with the errors and sending some information so splain text will just work fine now let me give you some demo on this one send mail task and this is going to be very simple demo better in the next demos we are going to create some complicated of packages and make use of expressions attachments and they create the care the files and send them and all those kind of thing we will do here when you open the send mail task what we are going to see here three options in general you can change a name if you like in description you can change the description here go to the mirror and now you will see SMTP connection so we have to create a desk SMTP connection click here new connection and you can provide the name and description here as well so we can call it tech brothers SMTP server and now we have to provide the SMTP server name itself so in my case I have TBS a client that's our SMTP server there is a separate video we have created how to create a SMTP server on your local boxer so you can go ahead and watch that video in the DBA tutorial mister I will try to put that link in the description as well now we will be using Windows the attempt equation if you will be using a this package of to run by the sequel server agent you your sequel server agent is running by some service account that service account will be part of your domain and that that but that will be just fine if it does throw you some error you can ask your essays or whoever manager SMTP server and they can fix that problem for you now hit OK and here we will be providing from so in my case I'm going to use Armour sequel age at the rate of gmail.com so that's in the from and I want to send an email to tech brothers see college at gmail.com and here we can if we want to CC to somebody we can write it and if you want to BCC somebody we can write it here in the subject we can write anything my SSIS package completed with success so next you will be director input message source cyber so here we are using direct input you have the options here you can have file connection or becoming where values coming from the variable we are going to go and perform demos on these as well so for now just we will be sent direct input and here I'm going to write here it is done so that's fine here you can come back and set the priority so we have normal low and high so you can go ahead and set normal in our case we don't care an attachment or if you want to send some attachment we can browse to any file and then select that file and it will send attachment so we have expressions here I'm going to have another demo where I will go and use the expressions so stick around and watched your video so this is going to be very interesting how to make use of this simple task and create very complicated emails so now we are all set let's say it okay if we run this package it should complete successfully it completed now we can go and take a look if we got the email so let me open this one and here sorry I have a lot of tabs open so let me see here now we have a email coming from almost equal age and then here is the email it's an it is done and this is the attachment that we use in the cell the mail tasks so that's how you will be using a central task but this is very static if you see that here we use pretty much every value we wrote by ourself so tomorrow if somebody don't want to use this account in production they have different the counter in your tea they have different the counter so and here may be the list of the recipient they will be different or so right now we are sending to one person maybe it will be ten percent so we have to how to send the email or concatenate those different email addresses and then you have subject that will be that can be created as a dynamic so I'm going to do a lot of demos here so stick around thanks very much for watching this video and I will see you in the next video