No announcements
Found 3900193 threads
-
0 Voteshow to send mail from SSIS Package using Send Mail Task
maybe you can follow the steps from this link: http://plexussql.blogspot.se/2010/01/emailing-error-log-file-as-attachments.html or you can use ...Answered | 3 Replies | 3888 Views | Created by surendiran - Tuesday, July 31, 2012 9:59 AM | Last reply by DotNetMonster - Tuesday, July 31, 2012 7:33 PM
-
0 Votes
Not able to send a ZIP file as attachement in a mail using mail task
Please check the changes in firewall policy to send zip file over the mail, as it was working previously and there is no code change related to zip file ...Answered | 5 Replies | 2056 Views | Created by Avhilash - Friday, July 26, 2013 7:31 AM | Last reply by James Leatherbarrow - Wednesday, December 21, 2016 10:01 PM -
0 Votes
Sending mail with C# in SSIS
Hi, Check the below msdn link for sending the mail using script task in SSIS using C#.Answered | 3 Replies | 1309 Views | Created by blastoSO - Friday, December 27, 2013 11:07 PM | Last reply by Kiran Ganesh - Monday, December 30, 2013 7:46 AM -
0 Votes
T-SQL/SSIS Help in finding a file exists in a folder and then email
What i would do is Plan A: 1- Loop files -- read all the files in the "X:\abc_p" folder 2-use ...Answered | 4 Replies | 3197 Views | Created by coolguy123SQL - Wednesday, April 18, 2012 5:24 PM | Last reply by Nik - Shahriar Nikkhah - Wednesday, April 18, 2012 7:43 PM -
0 Votes
How to check whether the file exists or not in the respective path using ssis?
Hi All, Above answer solved my requirement to some extent,but now the requirement has extended in such a way that a folder contains three files whenever any one of ...Answered | 22 Replies | 8323 Views | Created by lakshmisudha - Thursday, January 17, 2013 4:26 AM | Last reply by Santhosh H - Thursday, January 24, 2013 8:28 AM -
0 Votes
Creating and attaching Excel File as Attachment In SSIS
Another indirect option would be to use SSRS to create reports and schedule it to send email with xls attachments.Answered | 9 Replies | 23593 Views | Created by CoolDbGuy - Saturday, April 7, 2012 10:21 AM | Last reply by Aalamjeet Rangi - Sunday, March 31, 2013 7:41 PM -
0 Votes
how to send a text file trough mail if the record exist in the stored procedure?
Check this attached pkg You may need to repoint it table and procedure you created.Answered | 5 Replies | 1936 Views | Created by Ychinnari - Friday, December 13, 2013 5:09 PM | Last reply by Visakh16 - Saturday, December 14, 2013 1:07 PM -
1 Votes
How to send an email using SSIS to the business user ?
If yes you can create a control table with this information Then use a script task inside the loop to identify the file pattern and send notification ...Answered | 2 Replies | 1488 Views | Created by kkran - Saturday, August 16, 2014 8:43 PM | Last reply by Visakh16 - Monday, August 18, 2014 8:25 AM -
0 Votes
how to send attachments dynamically in sendmail task using expressions
Hi you can use ole automation procedures to check the existence of the file and write the code to send the mail with the file that ...Answered | 3 Replies | 1419 Views | Created by lakshmisudha - Thursday, June 6, 2013 4:47 AM | Last reply by Sunil Enugala - Thursday, June 6, 2013 7:29 AM -
0 Votes
send email with result using send mail task in ssis
records are attached with file right?Answered | 8 Replies | 3288 Views | Created by Meerack - Tuesday, April 19, 2016 9:16 PM | Last reply by Eric__Zhang - Wednesday, April 20, 2016 10:45 PM -
0 Votes
SSIS; Send Mail Task
for second question you are right you need to use the ONerror event of the package or send mail task.Answered | 3 Replies | 7727 Views | Created by Jey-YoYo - Friday, October 14, 2011 5:05 AM | Last reply by _AKS - Friday, October 14, 2011 7:49 AM -
1 Votes
How to send a hard link to file path in an email using ssis?
I referred Arthur's posted content and was able to send hard-link by using Expressions.The expression had folder and file path and file ...Answered | 3 Replies | 2753 Views | Created by MLTC - Sunday, May 29, 2016 4:54 PM | Last reply by MLTC - Tuesday, May 31, 2016 2:23 AM -
0 Votes
Copying a file and send to a mail box throgh job
You can take a look at following blog entries SQL Database Mail - Send Emails with ...Answered | 5 Replies | 6097 Views | Created by Kranthirao - Wednesday, June 8, 2011 4:16 PM | Last reply by Kranthirao - Tuesday, June 14, 2011 3:01 PM -
2 Votes
Exception in Sending mail with C# task instead of SSIS mail task
I tried to send mail with both send mail task and a script (using C# ) which I got here ...Answered | 10 Replies | 9273 Views | Created by blastoSO - Monday, December 30, 2013 7:13 PM | Last reply by SSISJoost - Saturday, January 4, 2014 12:39 PM -
0 Votes
Mailing multiple attachments problem
It is trying to attach the files in the folder.Answered | 6 Replies | 1317 Views | Created by Retired_Fred - Thursday, September 21, 2017 6:37 PM | Last reply by Retired_Fred - Thursday, July 12, 2018 1:05 PM -
0 Votes
SSIS Package To send seperate emails via SMTP with each files in a directory
Point the enumerator to your folder.Answered | 4 Replies | 6852 Views | Created by Jon Opeth - Thursday, January 20, 2011 4:09 PM | Last reply by Sudeep Raj - Friday, January 21, 2011 6:39 PM -
0 Votes
How to Email file names from a Folder by using Send Mail Task in SSIS Package ?
In the ForEach Loop container, loop over all the files in a folder, and save each file name into a variable “MyFile”.Answered | 1 Replies | 2274 Views | Created by Julie Elizebeth Sam - Tuesday, June 30, 2015 5:37 AM | Last reply by DIEGOCTN - Tuesday, June 30, 2015 8:32 AM -
0 Votes
sending error log to mail
hi Koen the failure may be because the log gets created at runtime,so attaching it to mail may be the problem so how can i handle this or any alternative solution.Answered | 14 Replies | 3247 Views | Created by VJREDDY - Monday, February 20, 2012 11:43 AM | Last reply by Eshani Rao - Tuesday, February 21, 2012 1:45 AM -
0 Votes
how can we send the table information attachement using SMTP ?
Hello, Export the data as a (flat) file, then you can send the file as an attachment using the Send Mail ...Answered | 7 Replies | 2037 Views | Created by Ychinnari - Monday, July 22, 2013 10:34 AM | Last reply by Olaf Helper - Monday, July 22, 2013 10:46 AM -
0 Votes
Can Send mail Task be configured to send mail even if specified attachment is not accessible
But you can use aAnswered | 1 Replies | 2395 Views | Created by sapt - Tuesday, August 23, 2011 4:05 PM | Last reply by Todd McDermid - Tuesday, August 23, 2011 4:24 PM
No announcements
