If you are using Send Mail task to send the email, then in the OnError event of SSIS package you can configure the SSIS package to send emails, and you can use the Error description System variable in the Message body of Send Mail task, You can find the Error Description System variable inside the expressions of Send Mail task. I have created a video how to send email on package failure but I showed sending the email from C# using gmail smtp server. Another video I created on how to send email on package start and package end using Send Mail task, I think both emails can give you an idea th-cam.com/video/X4HooQ_xbNY/w-d-xo.html th-cam.com/video/wV2akLdQ640/w-d-xo.html
I have bit different requirement. I have to upload xml file but that file is generating dynamically as in we are not storing in local. But have to upload the dynamically created xml file to sftp server . Could you please help me
First you would need to create the file locally, you can't directly make the file on ftp server. So first create the file locally and then in second step you can easily upload them to ftp server similar to how we are uploading the flat files to ftp server.
hi sir aapki video boht useful hai mere liye Kya aap mera 1 doubt solve kar sakte hai mujhe 1 query daily run karni us query ka output mujhe online excel ke sharepoint par daily upload karna hai isko ssis me kaise karenge kyunki offline excel me hojayega lekin online excel me kaise upload kare
Thank you so much. This comes in handy since I have a task which I have to transfer files. This is so helpful.
You are most welcome Catusae.
Excellent tutorial using c# code upload the file(s) in ssis
Thank you Abhilash Sir.
Thanks you so much.🙏
You are most welcome Srinidhi.
please make a video on
if any task failed in loop how send email ✉️
If you are using Send Mail task to send the email, then in the OnError event of SSIS package you can configure the SSIS package to send emails, and you can use the Error description System variable in the Message body of Send Mail task, You can find the Error Description System variable inside the expressions of Send Mail task.
I have created a video how to send email on package failure but I showed sending the email from C# using gmail smtp server.
Another video I created on how to send email on package start and package end using Send Mail task, I think both emails can give you an idea
th-cam.com/video/X4HooQ_xbNY/w-d-xo.html
th-cam.com/video/wV2akLdQ640/w-d-xo.html
I have bit different requirement. I have to upload xml file but that file is generating dynamically as in we are not storing in local. But have to upload the dynamically created xml file to sftp server . Could you please help me
First you would need to create the file locally, you can't directly make the file on ftp server. So first create the file locally and then in second step you can easily upload them to ftp server similar to how we are uploading the flat files to ftp server.
hi sir
aapki video boht useful hai mere liye
Kya aap mera 1 doubt solve kar sakte hai
mujhe 1 query daily run karni us query ka output mujhe online excel ke sharepoint par daily upload karna hai
isko ssis me kaise karenge
kyunki offline excel me hojayega lekin online excel me kaise upload kare
Thank you so much, this was helpful.
IS there a way to connect using ppk or RSA key file instead of password?
Sorry not sure about that.
Hi @ aquil please do continuation video regarding to unit test
OKay, will try to make another video on unit test very soon.
@@learnssis thanks
where I can download the dll?
In the description of the video there is a link to download, there you can find the folder with the name of the video.
Can i upload 70gb software file
Not sure, you can try.