Hi all,

I can see my data perfectly in the data base with the Hebrew fonts, when I'm trying to generate a report all the Hebrew reordes are displayed as ?????.

Please your help.

Any direction to fix the problem.

Thanks in advance. 

Hi,

If data is appearing properly in database, then it must be in fecthing the data from database. While fetching data you need to mention proper datatypes as 'nchar' or 'nvarchar' so that it will fetch unicode character properly.

Hope this will solve your problem.

Hi ,

I tried this solution but didn't help.

But imoprtant thing , on my development machine (Vista one) I see the fonts properly, but on the production machine (Server 2003) this problem happens.

Is there something related to the machine .

Thanks

Hi,

Check which font is used in your application and is it present on your server machine? Also check whether Unicode font is

 installed on your server machine. There should be atleast one Unicode font install on machin, then only it will show you

 unicode character.

Please refer below link for more information about this.

http://msdn.microsoft.com/en-us/goglobal/bb688134.aspx

For SSIS issues, you can also ask at:

• SQL Server Team http://www.sqlteam.com/forums/
• SQL Server Central http://www.sqlservercentral.com/
• SQL Server at MSDN http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1