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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Encoding in DTS

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-08-10 : 09:42:13
Panchapakesan writes "I have a column which holds 2 byte chars(NVARCHAR)(Chinese, Korean languages). Now, I need to send the values of this column as a notification to users. I am using DTS, vbscript and the stored procedure sp_send_cdosysmail to send the notification. All the special characters appear as ? in the notification. In ASP, we can encode using Server.HTMLEncode method. Can we do a similar thing in DTS?"
   

- Advertisement -