Answer Questions

• MMDG Analysis Services 2000 - Selecting a dimension's default member based on a member property

  Hi there, I'd like to write an MDX stamement that selects a certain month of my Time dimension based on a Month level member property, FLAG_LAST_MONTH. I tried SELECT {Date.CurrentMember.Properties("FLAG_LAST_MONTH")} on rows, {} on columns from MyCube but I get an error that points to the Properties token. What is wrong with my sintax Regards, Pedro Martins Hi Pedro. I see nothing obviously wrong with your syntax. What is the error A few other itrems to check are: (1) Execute your query and reference month members on the columns: SELECT {Date.CurrentMember.Properties("FLAG_LAST_MONTH")} on rows, {Date.Month.Members} on columns from MyCube (2) Is "FL ...Show All

• clue Multivalued parameters in ReportExecutionService2005

  Hi all, Does anyone know how to pass the multivalued parameters to the report server via SOAP API I read the declaim from MS they support this feature in ssrs2005. But I cannot find any document about how to use it. It seems there is parametervalue class still and no iterator support in this edition. Do you know how Appreciate your replies Henry I found it was quite simple, just set the multiple values using the same parameter's name. I don't know  if there is another way to achieve it.  Welcome more replies ...Show All

• Marcos Bertoldi Conversion failed when converting the varchar value

  I keep receiving this error: Conversion failed when converting the varchar value 'INSERT INTO temp_tableZ (Customer_Category_Key, Item_Category_Key, Sales_Rep_Key, time_member_key, Revenue, Fiscal_Year ) select Customer_Category_Key, Item_Category_Key, Sales_Rep_Key, ' to data type int When running the code below. I believe the problem has something to do with the @time_member_key in the dynamically created SELECT statement. However, I don't understand the problem or how to fix it. Can anyone provide some advice thank you, Erik drop table temp_tableZ go create table temp_tableZ ( Customer_Category_Key INT NULL, Item_Category_Key INT NULL, Sales_Rep_Key INT NULL, Revenue money NULL, time_member_key ...Show All

• Chris Lively Help with Sending file to server using ftp task

  Doe anyone know how to do this. I keep getting an error remote path missing "/" but it doesn't contain a "/". Mike If you could give more detail, that would help. I figured it out using a ftp script. Did you try putting a "/" in front I'm trying to connect to a FTP server running on z/OS and has MvS operating system. The remoter parameters In the FTP task editor in ssis calls for a "/" at the beginning of the remote path but the remote path I am uploading to starts out with a single quote and not a forward slash. Is there a way around this thanks, Mike That's what I have had to resort ...Show All

• 大頭仔 Can't connect to server

  I reinstall sql server develope edition. Then I try to connect the server from another computer, it shows below infomation. But in server property, it allows remote connection. I don't know whether it was caused by reinstall. Before reinstall, I can connect to the server, but it's edtion is group version. And edition for client is also group version. Any one can help me Thank you very much! TITLE: Connect to Server ------------------------------ Cannot connect to *.*.*.*. ------------------------------ ADDITIONAL INFORMATION: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under t ...Show All

• pdurbha Why Replication?

  Hi, all here, I really dont understand the use of replication in SQL Server 2005 database engine. My concern is: Replication is used for copy database objects. But we have already have backup, snapshot methods for that. I dont really see the advantages of using replication Thanks a lot in advance for any guidance and advices for that. With best regards, Yours sincerely, replication has its place. for instance, you have a need to keep the publisher and subscriber in sync at the almost real-time. also, you can do 2-way (i.e. merge/peer) replication which the data flows both direction. you can't really do that with backup & restore without a major downtime. Hi, oj, thanks a lot. With best regards, ...Show All

• tadeusz s. Error While connecting to Unidata from SQL 2005 using OLEDB connection

  I have been using SQL 2000 DTS to connect to Unidata (this is a non-relational databaseo owned by IBM) using OLEDB connectors from IBM. It has been working well in SQL 2000. When I connect to the same datasource from SQL 2005, I get the following error message. I am connecting from Integration Services. I would appreciate any help in resolving this. Thanks. Warning at {E7C1769A-C334-4AE6-A3D9-3DF117775D40} [OLE DB Source [1]]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support th ...Show All

• irl-barse SQL Server Express is working - what tool do I use to create database and tables?

  Hello, I have SQL Server Express working however I don't see any tools to create a database and tables. I am trying to create a database to store stock quotes that I will input from a c# program. What tool should I use to design the database Thank you! Toben hi Toben, please have a look at SQL Server Management Studio Express at http://www.microsoft.com/downloads/details.aspx familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en regards hi, as regard database deployment, have a look at http://msdn.microsoft.com/msdnmag/issues/04/09/customdatabaseinstaller/ , which uses a "method" based on scripts that has several benefits.. obviously this one can be easely integrat ...Show All

• Faraz_Ahmed Access project connecting to SQL 2005

  Most of our users are using MS Access project to work with our data in SQL Server 2005. The problem we have is that in order for them to access the tables they need to be given db_datareader and db_datawriter permission on the database. Our goal is not to give access to the tables themselves but to views. Therefore, we've created several views and placed them into a particular schema. Now we want to give access to that schema, but when we assign select, delete, insert, and update to that schema user in ms access project aren't able to view these tables. When we give them db_datareader permission they are able to see the views but in parentencies does not show the correct schema; therefore, when you try to open that view it errors out sayin ...Show All

• rp1933 problem with loging in

  I installed a default instance of Enterprise edittion and didn't face any error during the instalation process. In Management Studio in the Server Name section for loging in I wrote the name of the local system. but I couldn't log in. in Control Panel \ administrative tools\services there is no SQL Server service at all. should I install any thing extra just like Express Edition which I used to install SQL Express in Visual Studio 2005 pakage or like MSDE in SQL Server 2000 please tell me what to do thanks. pooyan Hello, It would seem that the core dbms has not been installed correctly - did you perhaps only select client tools during the install Reinstall t ...Show All

• Darko01 Installing/Deploying a .dtsx package

  Hi, I used to write DTS Scripts in SQL Server 2000 and schedule them as jobs with out problem. This was normally done within SQL Server its self. Now that I've moved to using SQL Server 2005 I've been learning how to use SSIS. I've successfully developed a package and managed to create a .dtsx file. Now I have 2 large books on the subject of SSIS but none seem to go into any detail on what to do next. So here’s my newbie question (I apologise if I sound dumb!): I don't want to run my package manually as the books keep telling me how to do. I need to have my package added into SQL Server 2005 somehow and then schedule it as a reoccurring job. Can anyone point me in the right direction Thanks Matt. ...Show All

• chetwynd How to define a user variable on Execute Sql Task??

  Hi everyone, How to define a Input variable in a Execute Sql Task I've defined a User::Inicio variable which contains 4 as value. In Parameter Mappins it has been defined. Then, I've gone to General->Sql Statement and allocated the following SQL Statement: UPDATE CARGAPROCESOS SET FECHAULTIMACARGA = [Inicio] or UPDATE CARGAPROCESOS SET FECHAULTIMACARGA = [User::Inicio] Anyway, I'm stuck, both did not work Thanks in advance for your comments Hi, You mean you want to use the user variable in your query right Refer this: http://msdn2.microsoft.com/en -us/library/ms141003.aspx Well, the error talks abour the ResulSet porperty; what is your value for that wha ...Show All

• Josue Perez test deployed packages

  hi all, i've followed the tutorial in SQL Server 2005 for deploying packages. everything works ok until i came to lesson 3 installing packages. i could connect to SSIS but when i expanded the Stored Packages node, i get an error message saying : Login timeout expired An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. named Pipes Provider: Could not open a connection to SQL Server[2]. (Microsoft SQL Native Client) my database engine has an instance name. will this affect SSIS connectivity thanks! thanks a lot, Jam ...Show All

• Kolja DTS import stores the last {LF} in Table.

  Hi i have a csv file where the last column usually happens to be null. So my file is like this: 1,2,3,,{LF} 4,5,6,,{LF} 7,8,9,,{LF} {CR} I run the dts export from csv file to db and it doesnt save the last row (column5) in the table us null. instead it stores the {LF} character. Ascii =10. How can i resove this problem. the csv comes from a third party application. the DTS needs to un automatically and somehow resolve that last problem on its own. but how is there a code that can trim the last character in the last line to delete the last {LF} or some query in DTS that can achive this..... DaPosh wrote: 16896,"Optioned",25510,65,0,,,,20060920,25510,FALSE, 16897,"Optioned",255 ...Show All

• Cezary Report Manager Issue

  I have created a parameter in a report, then deployed it Report Manager - this is the issue - People with only one budget department brought a Reporting Services problem to the forefront - drop-down list boxes seem to be made large enough for x-1 of the items in the list.  If there's only one item in the list, the listbox is so small that you can't see the item in the list.  Does anyone know how to change the format of some of the stock controls in RS   This is a known issue that was recently fixed in a QFE. The QFE is not a public QFE so you will need to contact Customer Service to get it. You can refer to KB 919556. ...Show All