No announcements
Found 3899899 threads
-
0 Voteshow to send a mail if anyone of the file exists in the folder with attachement using ssis
Have three send mail tasks, one for each case, and then you can set a variable inside a script task based on what files were found using .net code (that will check ...Answered | 1 Replies | 1529 Views | Created by lakshmisudha - Tuesday, June 4, 2013 5:27 AM | Last reply by ArthurZ - Wednesday, June 5, 2013 2:58 AM
-
0 Votes
How to send a mail with attached Text files in SSIS 2008 R2
Try ...Answered | 3 Replies | 2397 Views | Created by Vasu2049 - Friday, September 21, 2012 6:58 AM | Last reply by Raunak J - Friday, September 21, 2012 9:04 AM -
0 Votes
how to attach latest file from the system and send mail using send mail task
Have a SSIS package with below structure 1.Answered | 1 Replies | 1821 Views | Created by vasu_479 - Friday, October 10, 2014 9:47 AM | Last reply by Visakh16 - Friday, October 10, 2014 10:21 AM -
0 Votes
How to send mail using SSIS?
I have used the SMT (send mail task) provided you should have access/permission to the SMTP server.Answered | 2 Replies | 4372 Views | Created by Jagadeesan Kandasamy - Wednesday, July 21, 2010 11:49 PM | Last reply by manalla - Thursday, July 22, 2010 5:28 AM -
0 Votes
Send a PDF file as an E-mail attachment from Network folder using SQL Server 2005 e-mail - issue
One another option is designing a small SSIS package with send mail task.Answered | 3 Replies | 7186 Views | Created by SSRS New Bie Beginner - Sunday, June 20, 2010 6:24 PM | Last reply by Sorna Kumar Muthuraj - Monday, June 21, 2010 12:18 PM -
0 Votes
Files exists check in the folder using ssis
It's the SSIS Script Task (part of the Control Flow)... but with some .Net code to do things that are hard to do with the out of the box SSIS tasks.Answered | 3 Replies | 1793 Views | Created by lakshmisudha - Wednesday, May 29, 2013 5:18 AM | Last reply by SSISJoost - Wednesday, May 29, 2013 6:40 AM -
0 Votes
How to send excel file from ssis using send mail task without saving the excel file locally.
Just as Arthur said, Send Mail Task only accept attachment file from a location, locally or remote.Answered | 4 Replies | 6566 Views | Created by Manoj Gowda - Tuesday, July 14, 2015 7:36 AM | Last reply by Katherine Xiong - Thursday, July 16, 2015 8:18 AM -
0 Votes
SSIS Newbie - How to send records from a table in an e-mail attachment using SSIS package
Hi, If you want to send results as an attachment, you need to write the data to CVS/Excel file and then attach to email.Answered | 1 Replies | 7698 Views | Created by SQL_Anfänger - Thursday, July 7, 2016 8:37 AM | Last reply by Aamir Shahzad Warraich - Thursday, July 7, 2016 12:58 PM -
0 Votes
Using SSIS - sending html mail
Hi hotbox, The below link will be usefull for you, here i have mentioned how to embed weblink while sending ...Answered | 2 Replies | 2404 Views | Created by Hotbox - Friday, March 1, 2013 8:24 AM | Last reply by Naveen Kumar K.R - Tuesday, March 12, 2013 11:36 AM -
0 Votes
Send Mail with Attachments
Hello NTMS, You can use the Add method of the Attachments class for adding attachments to the mail item object.Answered | 3 Replies | 1156 Views | Created by GC2006 - Thursday, January 2, 2014 3:02 PM | Last reply by Eugene Astafiev - Friday, January 3, 2014 7:53 PM -
0 Votes
send mail task in ssis
these are some links .for Send mail task .Answered | 5 Replies | 7756 Views | Created by Gangadhar Thumu - Friday, July 15, 2011 7:59 AM | Last reply by Ajay Singh Rawat - Friday, July 15, 2011 11:16 AM -
0 Votes
Send mail with attachment
One and ONLY ONE file?Answered | 1 Replies | 4647 Views | Created by SSAS BT - Tuesday, June 7, 2011 11:11 AM | Last reply by Todd C - Tuesday, June 7, 2011 12:13 PM -
4 Votes
How to send a dynamic files attachment by send mail task?
The attachments will be located on a seperate server, with a shared folder that the current server has access to.Answered | 4 Replies | 26306 Views | Created by P.Chonnathan - Friday, January 19, 2007 7:35 AM | Last reply by real_Egis - Thursday, October 18, 2018 10:18 AM -
0 Votes
How to send multi-attachments by SSIS Send Mail Task
http://msdn.microsoft.com/en-us/library/ms142165.aspxBlog: http://dineshasanka.spaces.live.comAnswered | 2 Replies | 14246 Views | Created by JohnnyKahWang - Thursday, April 1, 2010 10:18 AM | Last reply by Dinesh Asanka - Thursday, April 1, 2010 10:49 AM -
0 Votes
how to attach file to send mail task
which version of SSIS you are using?Answered | 3 Replies | 1790 Views | Created by maheshbabuk - Sunday, June 2, 2013 1:53 AM | Last reply by Khilitchandra Prajapati - Monday, June 3, 2013 3:56 PM -
0 Votes
Sending file attachments in SSIS only if rows returned
I am using row count variables with precedence constraints.Answered | 7 Replies | 2411 Views | Created by David Lazarus - Monday, November 24, 2014 8:14 PM | Last reply by David Lazarus - Wednesday, December 3, 2014 9:42 PM -
1 Votes
Sending Mail Using SSIS
In either case of using a Script Task with System.Net or the Send Mail task, you will need the SMTP server to send the email message.Answered | 4 Replies | 9859 Views | Created by Sharath048 - Monday, May 9, 2011 1:01 PM | Last reply by Sharath048 - Tuesday, May 10, 2011 5:03 AM -
0 Votes
Getting validation errors from Send Mail with attachment
Hopefully, the log file from the first package will be free for use by the time the Send Mail task wants to attach it.Answered | 6 Replies | 10143 Views | Created by Maggie3614 - Wednesday, January 5, 2011 4:24 PM | Last reply by Maggie3614 - Wednesday, January 5, 2011 5:20 PM -
0 Votes
How to send mail from database table using SSIS
You can use a Data Flow Task to read the error table and place it in a Flat File Destination, then use the Send Mail Task to attach the text ...Answered | 3 Replies | 4681 Views | Created by Pankaj067 - Thursday, May 3, 2012 5:07 PM | Last reply by Todd McDermid - Thursday, May 3, 2012 6:49 PM -
3 Votes
SSIS Send Mail Task - Failure Sending Mail
I found a work around to send email in an SSIS package if your smtp server requires authentication.Answered | 10 Replies | 41525 Views | Created by John J Parker - Thursday, June 8, 2006 1:18 PM | Last reply by jdneilso - Wednesday, September 15, 2010 2:33 AM - Items 1 to 20 of 3899899 Next ›
No announcements
