Dose SQL Server Integration Service Support Farsi (Persian) Language?
Mar 31, 2008
Dose SQL Server Integration Service support Farsi (Persian) language?
I passed a column of a Farsi text database to Term Extraction component put it didn't send anything to output (destination).
I even use CodePageConvert (http://www.microsoft.com/downloads/details.aspx?FamilyID=9E56417E-23D1-4FD3-8D6D-61314FAA2DE3&displaylang=en) between Source and Term Extraction, it seems that it converted the text but still nothing comes from the Term Extraction.
Hi, This is chirag patel. we are going to develop web application which can disply data (Search Results) in different language. if user selected country Japan, then search results should be in Japanese. if user selected country Chian, then search results should be in Chinese. now i want to store all these read only data in Database. how and where i can store it? do i need to have different Databases? or with single database also i can achive? I means what is advisable approach to achieve this?
if Single Database for all countries then how i can store same data in different languages in single table?
please guide me if anyone know how to achive such kind of scenario in SQL Server?
I am trying to execute a query which has the Greek letter as below. But it is not returning any rows even though I have a row exists in database matching the condition below.
select ID from pmf where portfolio = 'ãç1'
I am using the ODBC connection to execute the query.
i wanted my database to support hindi language. how will i implement that? i mean i don't see the hindi_bin for the collation options. do i have to install extra unicode support for the hindi language? or is there anyother way i could implement that?
Hi,I have a database and want to store data in Spanish and English. Toaccompish this:1. Do i need to create separate tables for both the languages likeitems_en and items_sp?2. If I opt for the UTF16 charset what single collation setting can Iuse?Thanks and RegardsJackal Hunt
I have Sql server 2008 database with 200 GB in production.But It will not support multilanguage Since all the tables and procs is having varchar datatype.
I need to change the Entire Tables and procs to support Multilanguage(nvarchar,ntext) .
I have Many Huge data tables with numerous index .ALso I could not afford too much down Time. How can I perform.
i need to change the production database structures with multi language Support , datatype from VARCHAR to NVARCHAR in all SQL Objects SQL Objects: Tables, Functions, Stored Procedures...Some of production Tables with 15 Croces records with 10 indexes.how to change the entire databases through SQL scripting
Hello! I have the following problem. I developed CLR Stored Procedure "StartNotification" and deploy it on db. This sp calls external web service. Furthermore, this sp is called according with SQL Server Agent Job's schedule. On my PC SQL Server works under Local System account and this web service is called correctly (Executed as user: NT AUTHORITYSYSTEM). But on ther other server the following exception is raised during job running: Date 17.04.2007 16:42:10 Log Job History (FailureNotificationJob)
Step ID 1 Server MSK-CDBPO-01 Job Name FailureNotificationJob Step Name MainStep Duration 00:00:00 Sql Severity 16 Sql Message ID 6522 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0
Message Executed as user: CORPmssqlserver. A .NET Framework error occurred during execution of user defined routine or aggregate 'StartNotification': System.Security.SecurityException: Request for the permission of type 'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. System.Security.SecurityException: at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet) at System.Security.CodeAccessPermission.Demand() at System.Net. The step failed.
What is the reason of this behaviour? Unfortunately I do not have direct access to this server. I have the following guesses: 1) CORPmssqlserver may have not enough permissions to call web service 2) Something wrong with SQL Server account's permissions 2) Something wrong with SQL Server Agent account's permissions I will take the will for the deed. Thanks.
We should support multiple language(Latin,chinese,japanese,korea) in one report when exporting to PDF format in reporting service. We have used Arial Unicode as our font. But when we exported the report, the korean language item can not be displayed. Any idea on that? Thanks a lot.
Hi all , What is the best solution for reading/writing Persian Date from/into SQL Server 2005 and do calculations on it?Note That I connect to sql server database from a .Net App. Any help would be appreciated . Thanks in advance.
I€™ve been trying to add keywords to the thesaurus used for SQL Server 2005 Full Text services but do not seems to get any improved results. For example, I have a catalogue of article titles which contains titles such as €˜CRM€™ and then some others use the words €˜Customer Relationship Management€™, the ideal solution I would have thought was SQL Servers thesaurus support, I€™ve been though and added the values:
to the txGlobal.xml file in the SQL Servers FTData directory, I then amended by test query to use this clause: FORMSOF(THESAURUS,"CRM") The idea being that when I search for CRM it will bring back articles with Customer Relationship Management also. However I€™m just getting results for the same results as for the word 'CRM' and no expansion is taking place it would seem.
Would anyone be able to clarify what the best approach to making this work would be:
Do I need to restart the SQL Server FullText service after making any changes to the XML files? (Done this, no sucess)
Do I need to restart the SQL Server service after making any changes to the XML files? (Done this, no sucess)
Do you need to re-populate the full text catalogues after making a change the XML files? (Done this, no sucess)
If this syntax correct when trying to utilise the thesaurus? CONTAINSTABLE (Article_Metadata, *, €˜FORMSOF(THESAURUS,"CRM")€™ ) (It doesn;t give any errors, just no improved results over: CONTAINSTABLE (Article_Metadata, *, €˜"CRM"€™ )
A coworker of mine is experiencing some problems with SQL Server Integration Services (SSIS) and long running Web Service calls. Any feedback on the problem would be greatly appreciated.
The problem is as follow: He has a large SSIS-package that, among other things, contain a few Web Service Tasks. All of the tasks are executing as expected for small amounts of data. All the Web Service Methods have in common that they have a long running time. The running time depends on the amount of data.
During requests with large amount of data the Web Service task fails with the error message €œThe operation has times out€?, but on the server they see that the service call completes as expected (after quite some time, approx 200sec).
The Web Service tasks are using an €œHTTP Connection Manager€?, created in the SSIS package. The timeout-value is set to 300 sec (which is the largest value for the property). My coworker expected that this value was the same as setting the timeout value for a Web Service proxy object for any other project.
After testing the Web Service from a Console application, with 300 sec timeout, the app executed as expected with no timeout exception.
After doing some testing, he€™s quite sure that the SSIS task times out after 100 seconds, which is the default .NET 2.0 timeout value for a WS proxy, even though the timeout property in SSIS is set to 300 seconds.
As a work around he have created a console application that does the web service call, and then use the €œexecute process task€? in SSIS. This is off course a €œdirty€? hack, and he want€™s to use the €œHTTP Connection Manager€? task instead.
So the question is: Have anyone experienced this problem before? Is there a limitation on the HTTP Connection Manager task? Is the timeout value on the HTTP Connection Manager task the same as setting the timeout property on a WS proxy? Why isn€™t this €œtimeout€? value picked up my SSIS?
Whilst working with SSRS within SSIS I came accross an issue when trying to create a Web Service Task using the SSRS Web Service. After pointing the task to the WSDL file when I tried to access the Methods of the web service I would get the '....WSDL is not supported.' error. I also noticed that selecting the Download WSDL button would throw up and error as well.
After a bit bit of playing around I found the following solution to the problem.
Make a copy of the ReportingServices.wsdl file and make sure it is not marked as Read-Only. Point the Web Service Task editor to this new copy of the WSDL file Set the OverwriteWSDLFile option in the Web Service Task editor to True.
You should then be able to access the details of the WSDL file and the methods of the web service. I am not sure if this issue is by design but hope that this information will help others who came across the same issue?
I am working on sharepoint 2007 integration with reporting service 2005. There are few facts which i am trying to understand and need some clarifications. Please provide your comments
1) While configuring "Database setup" in Repoting Service Configuring Manager" i found two modes 1) Native and 2) SharePoint Integration. When creating a report server database if we check "Create the report server database in Sharepoint Integration Mode" then it set the mode to "SharePoint Integration Mode". There is no option of switching the same database to native mode. So i have to create another database in "Native Mode". (IS THIS CORRECT. DO WE NEED TO CREATE TWO REPORT SERVER DATABASE SEPERATE FOR SHAREPOINT INTEGRATION AND NATIVE)
2) I am using the new report viewer web part in sharepoint 2007. When i am in sharepoint integration mode i can create datasource, report model and with report builder i can create rdl file. On selecing any RDL file in doument library and it gets displayed in Report Viewer Web Part. When i switch to Native mode i want to configure the web part to use the report created with SQL Server Bussiness Intelligence Dev Studio and deployed on http://localhost:808/ReportServer. (IS THERE ANY WAY SO THAT I CAN EXPORT AND IMPORT ALL .RDL FILE FROM http://localhost:808/ReportServer to http://localhost/ReportServer)
I AM NOT ABLE TO CONFIGURE WEB PART WHEN I AM IN NATIVE MODE i.e giving path of .RDL in report textbox throw a error saying "Item not found" i tried all combination. THIS can be related to datasource not reading in .RDL file in native mode while confuring report viewer web part.
http://localhost:808/ReportServer (Report Server)
http://localhost/ReportServer (SharePoint Mode) (Default Top Level Site)
3) LAST : I want to create a .RDL file report from the data in sharepoint, say lists or news etc. So when creating a RDL file how can i connect to sharepoint database. I read some where that in previous release they used to DATA EXTENSIONS and get the data from list in sharepoint with something like http://<servername>/<sitename>/List=Announcement when creating RDL file. Is the alternative in new release to create the report based on sharpoint list data.
Hi I am trying to run 4 - 5 store procedure in a strict order. I have created a SSIS package whereby I trying to execute store procedure in a orderly fashion. I have created constraints between them. Yet whenever I run the package - the store procedures run out of sequence. Is there something I can do to force the store procedure in orderly manner? Help will be much appreciated.
hi, can anyone explain, how to execute package with sql server agent:
the problem is::
i made a integration service package (in visual studio 2005). When I 'm in visual studio and do "execute" the package it works well. Then I build a dtsx file. When i double click on it, it opens and if i do execute, it works well.
I want to execute the package every week automatically. I write a job in SQL server agent, in Steps I choosed Type=SQL server Integration service packege, then General->packacge source -> file system, and then wrote where the dtsx file is (which was built). "Run as" I choose my user name.
then i'm trying to start a job, but it fails, and writes "The package execution failed."
I need to read in general web pages (not a web service) from a typical web site using SSIS and make it available for other SSIS transformations (Script Component). I tried using the XMLSource data source but this appears to require well formed XML, and will not accept HTML which is what I am likely to be getting from the web pages. I tried a HTTP Connection Manager with a DataReader Source, but seems to only accomodate web services.
Can this be done? If someone has an example (tutorial) of how to accomplish this I would greatly appreciate a copy. James
I am using sp_helptext to generate script of stored procedure. However someone said sp_helptext loss something if stored procedure is big. That means the script is not completed. Is it true?
This might be a very basic problem. I have two SSIS solutions. I was able to build SSISDeploymentManifest for one solution, but not the other. When I press BUILD, it does create dtsx in bin folder but I do not see any Deployment folder created nor manifest file. What did I do wrong?
