Answer Questions

• Santhosh Pallikara DMDecisionTreeViewer

  Hi, Anybody knows how to use DMDecisionTreeViewer from Microsoft Thanks in advance ....... :) You might try searching under ASP.NET forums http://forums.asp.net . So Where can I post question like this Or, could you please help me answer this question thoug may be it is out of the topic of this forum Thanks .... Please post queries related to SQL Server related queries in this forum. Thanks I've tried it but i found no answer..... Really need help .... ...Show All

• smadhu The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel

  I'm using SQL Server 2005 (SP1) Reporting Services on Windows Server 2003 SP1. I access the report server from Internet using SSL, but the server is not exposed directly to the internet. It is behind a firewall, where the required ssl port is setup and is working fine. In my Reporting Server, the /ReportServer folder works perfect and I can navigate and view all reports. It is the /Reports folder the one that does not work fine. I can enter the /Reports folder, and can list all the reports. But, when I select one of the reports, and it starts rendering, I get the error message: "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. The remote certificate is invalid according ...Show All

• Cris001 Book on Business Intelligent Reports ??

  Does any one know of a good reference or book dealing specifically with Business Intelligent Reports I need to figure out how to fully utilize the reports. Thanks Cal Surely someone has an answer to this question. Cal ...Show All

• Jarodtweiss Data does not fit....

  I am doing a simple update statement but am getting an error. Cannot create a row of size 10675 which is greater than the allowable maximum of 8060. The statement has been terminated. I am inserting data that is as big as 7500 characters into a varchar(7500) field. I have made sure that my column is 7500 in length. the only way it fits is if I cut it down to 4950 characters... Any Ideas In SQL Server 2000, the entire row's data must be <= 8060 bytes, not just a single column. (this allows it to fit on a single page) In SQL Server 2005, you can put > 8060 bytes on a row, but it is not advisable in most cases. Any rows that are larger than that spill over into a different page. ...Show All

• programmingisfun String data to int

  I'm trying to import a student id in one database (nvarchar(7)) to int in another database. No sure whether I need ato use cast or convert. Anyone have some examples Have you tried using a Derived Column Task The expression would be something like (DT_I4)([ColumnToConvert]) Not going to work unless you know for sure that all data in the [ColumnToConvert] column can be converted. Data Conversion transform could also be used. ...Show All

• George Tar Table existance in DTS

  Hello, In a DTS, I want to check whether a certain table already exists. If so, it should be deleted. Any ideas how I can do that ActiveX (if so, how) Use an Execute SQL Task, with some standard SQL as you would use in any object management script. You could use DMO in ActiveX Script but - 1 - It is harder I think 2 - It will not upgrade to SSIS as both ActiveX and DMo have been deprecated. Moving to the "SQL Server Integration Services" forum. ...Show All

• pugs Setup question...

  I have a normal 3-tier architecture. I am trying to use service broker to send messages from either the web tier or the app tier to the database tier. The problem lies with the versions of SQL we are using. We have Full SQL on the database tier (Enterprise) but we only want to install SQLExpress on the web and app tiers. Is there any way to have the web tier talk to the app tier and have it forward that on to the database tier I am aware of the limitation of Service Broker and two instances of SQLExpress, but I was just wondering if the app tier version was just forwarding the message to the database if it could still work Thanks! Thanks, Remus. One more question. We are using the Express ...Show All

• RaphaelGray Passing value inthe Query

  Hi All, I have problem creating query. here is the scenario I have a table EMPLOYEE , the fields are Employee Name, month1,month2,month3,..month12 thomas,100,1200,400...1200 wilson,500,1100,500...1000 carol,200,500,200... 3400   I am creating report using visual studio reporting services I am passsing the report parameter to the query, but i could not the actuall result MY PARAMETER  is 2 ( varrialble is gmonval) I am writing the query  like, select empname,"month"+Ltrim(@gmonval) from employee the result which am getting is thomas,month2 wilson,month2 carol,month2   it suppose to be thomas,1200 wilsom,1100 carol,500 how to get the above result. plea ...Show All

• Smockmakker Easiest and performance effective way to store blob into varchar column

  Hi, My package dumps the errors into a table. The problem is, it couldnt dump Error Output column to a varchar field. I have added an script component in between to transform to string but no success. I tried ErrorOutput.GetBlobData(0, ErrorOutput.Length) but when I query the database, it says "System.Byte[]' I will appreciate the responses to this post. Thankyou, Fahad Why are you using a script component Are you developing in BIDS The error output has all of the columns of the source plus two, ErrorCode and ErrorColumn. There isn't a field that contains ALL of the incoming data, unless you've defined the source as such. This post helped me, Thanks Phil Actually the Source was Unicode and I was using ASCII string in ...Show All

• krisvenki Credentials used to run this report are not stored

  Hi all, When I create a new report subscription in report manager, I got this error Credentials used to run this report are not stored any idea Thanks, Jone Thank you, Jarret. I used my user name an dpassword that I use to login my machine, and checked the 'use as windows credentials when connectingto the data source', and the subscription has been created. But I can't find the e-mail extension on the report. How can the e-mail extension or icon be availale on the report BTW, in sql server-->configuration tools--.report service configuration -->email settings, I input my e-mail address as the sender's address, and the name of our exchange server name as the 'smpt se ...Show All

• kickballMVP2006 People with same last name causing problems (Adam you there)

  I run a report which displays transcripts for members. One page per person with their name, courses they've took, date of the course and their score. The problem I am having is when the report runs and comes across the same last name for many people (say, Hanna and Billy Alexander), it's only giving me the first "Alexander" it comes across and it is putting all the information for the other "Alexander's" in that first transcript. How do I separate out the people who's last name is the same say "Smith" or Jones" I have a distinct clause on my query and when I run it I can see the other people with the same last name and their unique courses and scores (each of them have a unique member ID) - it's w ...Show All

• riemerg HELP accessing SSAS cube from distance

  hello to everybody. well i just put the ssas database to a distant server. well what can i do now in order to be able to access the cube from distance what component do i need to install to the remote pc and is there any way to access the management studio of the distant server from a remote pc(that is to say by clicking to a link can i have access to the server's managment studio ) well i want to give the possibility for more than 5 personns to access the cube. can i do that by installing sslserver express edition do i have to install managment studio to all posts thank u for your answer I recommend using Terminal Server. It is a part of Windows 2003 server and I thi ...Show All

• Santosh Thankachan DSV Refresh

  Hi, I have an odd problem with the creation of objects in the data source view using AMO. I added some tables and relations with AMO and everything seems to work well. Then, using Analysis Services I selected the data source view and refreshed it. The form that notifies the changes in the data source view showed a lot of changes that I didn’t understand, costraints created and removed, fields changed and other operations that I didn’t made... I try to do the refresh with AMO using all the update and refresh options I found but with no results. Every insight on the question will be of great help. Thanks This is an extract of the data source view refre ...Show All

• Pockey Object must implement IConvertible....

  Using: VB.Net 2003, SQL Server 2000 and nText Column... Examples: " Writing BLOB Values to a Database [Visual Basic]" and " Conserving Resources When Writing BLOB Values to SQL Server [Visual Basic]" I modified the following code from the samples that were available in Help and MSDN. When my application reaches the ExecuteNonQuery statement it informs me that the Byte Array oDocument must implement IConvertible. I have even tried the extended version which uses a SQL Insert followed by UPDATETEXT with Pointers, and I get the same result with the Byte Array used in that example. My goal is to have Users Append certain documents to Proposals within my database, as I understand that is what I would be doing an ...Show All

• Beckwith how to loop through several excel sheets in a file in integration services

  Hello, I'm new at Integration services and I have an excel file with information in several worksheets. I want to loop through some specific sheets to retrieve the data and save it in a database table. I know how to retrieve the data from one sheet, but I don't know how to do it for several sheets. Any ideas ...I would appreciate any help. Hi Rafael, Trying to use a DELETE statement against the Excel file yields an error message (the syntax varies based on where I click OK), but generally all say something to the effect of "Deleting data in a linked table is not supported by this ISAM. (Microsoft JET Database Engine)". So my only recourse seems to be, as you suggested, to (1) create a &quo ...Show All