Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gukguk
Starting Member
3 Posts |
 Posted - 2008-03-03 : 23:44:48
|
| HI !I need help to fix SSIS Send Mail Task Error.I have aData FlowRead from Sql Data base and then put the query result into excel file(OLE DB Source --> Excel Destination)Send Mail TaskEmail excel file from the data flowControl Flow :Data Flow --> Send Mail TaskThe package throws an error below. I tried to disable my antivirus because i thought it's throwing an error because of the antivirus.But, it's still throwing the same error. If i tried to send email without attachment, it works just fine.Is there anybody know how to fix this?Progress: The SendMail task is initiated. - 0 percent complete[Send Mail Task] Error: An error occurred with the following error message: "The operation has timed out.".Progress: The SendMail task is completed. - 100 percent completeTask Send Mail Task failed |
|
|
leo25july
Starting Member
1 Post |
Posted - 2008-04-22 : 09:13:18
|
| Hi,I am new to sql server 2005 SSIS and have a recent requirement where I have to create an excel file through SSIS and then email it as an attachment.Can you please guide me as to what needs to be done here? A sample code or any other help as you deem it to be fit will be very much appreciated as I am a novice when it comes to SSIS.Thanks in Advance |
 |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-04-22 : 13:14:17
|
| How about scaling down the Excel file size and see if it still times out? Or how about attaching a different file (any) and see what happens? |
|
|
|
ankitbhurat
Starting Member
9 Posts |
Posted - 2008-04-23 : 09:16:42
|
| Try to attach a small file may be a TXT, and see is this throws the error again. |
|
|
|
|
|
|
SSIS SEND MAIL TASK EXCEL ATTACHMENT TIME OUT