@@TechBrothersIT 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 Please please help me as I am new to this I need your guidance @TechBrothersIT please help me
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.
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
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?
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.
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!
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
May you be blessed! I needed to do this for my job and it worked.
Your is the best channel when it comes for the ssis tutorial sir. You have been a saviour in many situations.
Happy to help. Thank you
@@TechBrothersIT 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
Please please help me as I am new to this I need your guidance @TechBrothersIT please help me
As usual, so perfect. Thanks a lot for such a valuable tutorial.
Very well explained. Thanks
Thanks very much for this video. useful for me to create email task
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.
Which SMTP Server did you use guys?
You guys rock
thank you!
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
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?
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.
amir sir could you please provide a link to create smtp server video.
Hi Ali Salam,
I have to check with Raza if he has created this video. I am afraid he did not upload this video.
Thanks
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!
sure sir thank you
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
In that case provide a drop box location when user or client can access the physical file itself.
@@dilipchauhan5598 thanks Dilip
@@shaikshahid7175 ah sorry I saw after relying that the comment was made 4 years ago 😀
Very nice, but bit toot fast for tutorial mode, in learning mode no need any excitement