.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Asad Ali
Post New Web Links

SSIS 2005 - Send Mail Task - signature appended to email is garbled - unicode problem?

Posted By:      Posted Date: September 02, 2010    Points: 0   Category :Sql Server
 
Hi, I'm pretty new to SSIS so go easy on me. I have a Send Mail Task to notify if a file cannot be imported - the mailbody is created on the previous step by a VB.NET script task to include the name of the file and the path it's been archived to. The problem I'm having is that while the body of the email I've created is displaying fine, our company's Exchange server appends a signature to all emails, and this is coming up as undisplayable characters, presumably due to some kind of unicode encoding problem. I've tried casting the email body in an expression to DT_STR (doesn't work as DT_STR "cannot be converted to a supported type" which seems a bit odd but never mind), DT_WSTR (garbled signature), DT_TEXT/DT_NTEXT (strange error on this one - "Attempted to read or write protected memory") none of those ideas worked, and I'm a bit stumped now. Can anyone help? I'm using SSIS 2005 with SP3


View Complete Post


More Related Resource Links

How to generate an excel and send it as email attachment in SSIS 2005 Script Task Component?

  

I am using a "Script Task" component. I am trying with following three simple steps:

1) Obtain the excel content in HTML

Dim reportInHtml As String = GenerateHTMLReport()

2) Generate an excel with below code:

Dim message As MailMessage

message = New MailMessage(fromAddress, toAddress, subject, String.Empty)

Using memoryStream As MemoryStream = New MemoryStream()

        Dim contentAsBytes As Byte() = Encoding.UTF8.GetBytes(reportInHtml)
        memoryStream.Write(contentAsBytes, 0, contentAsBytes.Length)
        memoryStream.Seek(0, SeekOrigin.Begin)

        Dim contentType As ContentType = New ContentType()
        contentType.MediaType = "application/ms-excel"
        contentType.Name = "Excel_Report.xls"

        Dim excelAttachment

send records as weblinks through send mail task in SSIS?

  
Hi All, i have a table with two columns and two records as follows. TypeOfReport                       Links InvalidRecords                http://ReportInvalid MissingRecords               http://ReportMissing --------------------- I have a package with execute sql task selecting * from the table above, full result set selected and an object variable created, it works good. but now when i connect it with send mail task, i wanna send email like Subject : Reports On InvalidRecords and MissingRecords MessageText : Links for the Reports : http://ReportInvalid                                                     : http://ReportMissing Can somebone help me with it. NOTE : i tried creating user and object variable but its good if i have only one record in table. i tried creating 2 user and 2 object variables as well but didnt work. Thanks

SSIS Send mail task

  
In the Send mail task, I want to use a variable in the To:(recipients of the email message) of the task. So I declared Emailrecipients variable as a string. In property expressions editor of the Send mail task: I wrote the follow expression: Property: ToLine Expression: @[User::Emailrecipients] In the send mail task editor, in the To line, what should I write? Thanks.  sqldev

SSIS Send Mail Task - Failure Sending Mail

  
Dear all, I have switched off the firewall settings on my system and as suggested im entering the minimal information and data to send the mail. but still the Mail Task is failing.. plz suggest.

SSIS Send Mail Task - Failure Sending Mail

  
Hi Everyone, Hopefully someone out there will have an idea as this is driving me nuts. I've setup a task to email on success/failure and keep receiving the following message when executed: Progress: The SendMail task is initiated. - 0 percent complete[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.". Progress: The SendMail task is completed. - 100 percent completeTask Send Mail Task failed When I configure Outlook Express on the same machine with the same settings it works. On the SMTP Connection Manager I have left the default name, tested with both an IP address and Server Name, and no authentication or SSL. On the Send Mail Task, it uses the above connection. The To: , From: , Subject  fields are populated. Message SourceType is DirectInput, MessageSource is Test, Priority is Normal and no attachments or expressions etc. Nothing useful is logged in the Event Viewer even with full logging turned on. Any suggestions appreciated, Thanks.

SSIS Expression to send email with dataset on the Mail Subject line.

  

Hi

I have a task - I need to email total number of products sold on the subject line of the mail task.

I have Execute SQL task process like select count(*) from tablename. Then I need to Mail the result set like "Total products sold September 2010 : 15000" on teh subject line.

I created a variable bit i dont know how to assign it on the subject line of the Send Mail Task.

I would really appreciate if you can guide me.

Thanks for your help.

Febten


Problem to use unicode chars in yahoo mail

  
Hi i have a problem to send email via smtpClient class to yahoo mail. if i send a unicode email from non-Yahoo account to yahoo mail, it works correctly (display unicode chars correctly without any making change), but when i send from yahoo account to yahoo mail, it does not display characters correctly and i should change it's encoding to UTF8. can anybody help me to work-around this problem ? Please see my previous thread in this link. thanks in advancehttp://www.codeproject.com/KB/codegen/DatabaseHelper.aspx

SSIS 2005 Control Flow Task Priority

  
The short version is I am looking for a way to prioritize certain tasks in SSIS 2005 control flows. That is I want to be able to set it up so that Task B does not start until Task A has started but Task B does not need to wait for Task A to complete. The goal is to reduce the amount of time where I have idle threads hanging around waiting for Task A to complete so that they can move onto Tasks C, D & E. The issue I am dealing with is converting a data warehouse load from a linear job that calls a bunch of SPs to an SSIS package calling the same SPs but running multiple threads in parallel. So basically I have a bunch of Execute SQL Task and Sequence Container objects with Precedent Constraints mapping out the dependencies. So far no problems, things are working and initial testing looks like it will cut our load time significantly. However I noticed that tasks with no downstream dependencies are commonly being sequenced before those that do have dependencies. This is causing a lot of idle time in certain spots that I would like to minimize. For example: I have about 60 procs involved with this load, ~10 of them have no dependencies at all and can run at any time. Then I have another one with no upstream dependencies but almost every other task in the job is dependent on it. I would like to make sure that the task with the dependencies is running before I pick up any of t

how send mail with out help of sp_send_dbmail in sql server 2005

  
Hi all, I want to sent mail using sp_send_dbmail but the hosing have problem as it require admin permission on master db so  they told me not use this SP is there any other method so that i can send the mail using SQL Server 2005  Thanks and Regards Er.Pradipta Nayak

Sharepoint 2010 WorkFlow Task AssignedTo Windows Group doesnt send email notification

  
Hi, Which configuration would prevent sharepoint to send a notification when a workFlow task is assigned to a Windows Group with an email ? The same task with a single User send a notification. Thanks, Patrice      

SSIS Web Service Task error : SQL 2005

  
On my dev machine every thing works, When i put my SSIS on QA server for testing, I get following error . Customer has only SQL 2005. Please provide any input on how to resolve this issue. I provided HTTP URL as .asmx?WSDL    already in config file.   Code: 0xC002F304    Source: Log Start Message to Process Manager Web Service Web Service Task    Description: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The input Web Services Description Language (WSDL) file is not valid.    at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil..ctor(Object connection, String downloadedWSDL)    at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()". End Error DTExec: The package execution returned DTSER_FAILURE (1).Moonis Tahir MVP, MCPD, MCSD.net, MCTS BizTalk 2006/SQL 2005/SharePoint Server 2007 (Dev & Config)

Send multiple parameters SSIS execute process task

  

Hi,

We are using Execute Process Task in SSIS package to execute a batch file to house keep the generated flat files which are older than a week from the archive folder.

The same batch file is used to delete the some temp files generated in the process.

As the Archive folder and temp folder paths are configurable, we are trying to pass the folder paths as parameters to batch file.

I used Expressions tab of Execute process Task Editor to map the variable to Arguments property. This is working fine. but I need to pass one more variable as an Argument.

Can some one help me how to achieve this. Thanks in advance.

Regards,

Sreekanth ABS

 

 


SSIS Script task design script problem

  

Hi,

  I have placed a script task in my SSIS project, package.

When I click Design Script button, script editor is not opening, instead its returning to Control Flow. But no error.

 What is the problem?

I just created a new folder in D:\ drive with the name My SSIS. 

 


Send Mail Task Error

  

Hi

i am using send mail task in a package which is giving me the error below.

Error: 2010-10-03 18:01:42.96

   Code: 0xC002F304

   Source: Notify Success Send Mail Task

   Description: An error occurred with the following error message: "Error in p\

rocessing. The server response was: 4.7.0 Timeout waiting for client input".

End Error"

"Send Email" activity doesn't send email to Google App mail only!

  

Hi, 

Suddenly i faced this issue this morning, SPD workflow can send email to all the domains except my Google App Mail domain.

It can send to gmail, yahoo, hotmail but it doesn't succeed my google app email!

i didn't change anything in google app mail setting or the local SMPT setting.

 

this is my IIS SMPT configuration

Fully qualified domain name:  mail.***

Smart host: smtp.gmail.com

TCP Port: 587


Consolidate auto workflow email and send one mail a day

  

Hi, I am facing an issue from so long and request you to provide any solution on the same.

I have created a document library and list where currently users are getting auto workflow email every time something gets uploaded to doc lib or list. However the requirement is to consolidate those auto emails so they will only get 1 summary email per day [i.e. all the file details in one email after end of the day which means “all files uploaded after 12pm midnight of (12<sup>th</sup> Oct) to 12pm midnight of (13<sup>th</sup> Oct)]

 

This seems to bit complex task and I was unable to find any solutions for the same. Please help me with the resolution/alternative
Regards, Sachin

Consolidate auto workflow email and send one mail a day

  

Hi,
I am facing an issue from so long and request you to provide any solution on the same.

I have created a document library and list where currently users are getting auto workflow email every time something gets uploaded to doc lib or list. However the requirement is to consolidate those auto emails so they will only get 1 summary email per day [i.e. all the file details in one email after end of the day which means “all files uploaded after 12pm midnight of (12<sup>th</sup> Oct) to 12pm midnight of (13<sup>th</sup> Oct)]

This seems to bit complex task and I was unable to find any solutions for the same. Please help me with the resolution/alternative

Regards, Sachin


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend