SSIS Tutorial Part 83-Create file with Date From SQL Server Table & Send as Attachment SSIS Package

SSIS Video Scenario:

We need to create a file with Date on daily basis and then send to our client in email by using SSIS Package.

Solution:

In this video we will learn how to solve above scenario, we will learn following components
How to create Parameters in SSIS Package
How to use Data Flow Task and read data from SQL Server Table and load to Flat file
How to write expression to create file with Date
How to use expression on Flat file Connection Manager in SSIS Package
How to Send a file as attachment by using Send Mail Task in SSIS Package
How to use Expressions in Send Mail Task in SSIS Package

Link to blog post for expressions used in the video

To follow Step by Step SQL Server Integration Services(SSIS) Video Tutorial By TechBrothers, please open below link.

[Damadedatos]

May you be blessed! I needed to do this for my job and it worked.

[dilipchauhan]

Your is the best channel when it comes for the ssis tutorial sir. You have been a saviour in many situations.

[aliazad]

As usual, so perfect. Thanks a lot for such a valuable tutorial.

[KalugampitiyaJayakody]

Thanks very much for this video. useful for me to create email task

[NoMercyNinja_]

Hey in most of your videos you created variables, but this time parameters. What is the main difference between the two and when to use one over the other?

[aakashr]

Hi Tech brothers Hope you are doing weel. I 'm working in a IT organisation and for our client I need to create a new SSIS package which will should contain only the coulns they have specified(client specified columns) and it should be automatically runs and send the report to them on time period they specify.

Iam new to SSIS Technology I'm learning it from scratch so I need your assistance in creating that SSIS package.

As of now I have created package which contains data flow, send mail task and file system task.

Whenever I try to run a package I'm getting the follwoing error in send mail task part " error: either file is not found at specified path or you don't have access to it"

The source file which I have in input folder is completely moved out to the archive folder which I have created after package execution.

But package executes successfully but I'm facing above error eithe rfile not found or you don't have access.

What I want is once package is exceuted on running it should send the email contans report in csv format and also the source file should be there in input with same name as I have created and in archieve folder there should be the copy of this csv file with date (date when its generated on execution).

Could suggest me what should I have do to fix this. Also please let me know how to set time period for running the package automatically and alsp help me for deployment

[akjay]

Hi, I have setup SQL server mail configuration & using that SMTP name as SMTP server name in SSIS 'Send mail task'. This is correct ?

While executing the SSIS. I AM GETTING BELOW ERROR.

Error: 0xC002F304 at Send Mail Task 1, Send Mail Task: An error occurred with the following error message: "Failure sending mail. System.Net.WebException: The remote name could not be resolved: 'MailNotification'".

Task failed: Send Mail Task 1

Thanks in advance.

[BashERC]

what if the smtp is secure and you have to use script task. how do you add the attachments? I have this issue where I have add the smtp using script task and when adding attachment it only show the path of the file but not attach it.

[FinFlare]

Man I really appreciate your work, but can you may help me with my problem?
I want to do the same as you with the difference that I want to send an excel file, how do I do this?

Thanks a lot!

[chaudhryalisalam]

amir sir could you please provide a link to create smtp server video.

[mario-t]

Very nice, but bit toot fast for tutorial mode, in learning mode no need any excitement

[shaikshahid]

What if My file size is around 30 MB as it has 2 Lakh Records, ,does this many Records can be send through file of SIZE 30 MB practically we cant send a 30 MB file thorugh EMAIl