Answer Questions

• ripleym Connecting to Sybase

  Hi, I am assuming someone has had success connecting to Sybase from SSIS. I am having trouble. And I freely admit naivety when it comes to something like this. :-) I installed dbConnector 6.01 which has a Sybase connector as a part of the package. I then tried to create a connection manager for Sybase using OleDb, but it was not an option in the list of OleDb connections. So, am I correct in assuming that I need to use ODBC If so, is there ...Show All

• Newsco How can we deal with unknown member in cubes for data mining?

  Hi, all here, I currently have a question about unknown member in cubes (as we know, there is always an additional member called unknown in an OLAP dimension)for data mining. I mean is there any way for us to deal with unknown member in cubes when mining cubes Thanks a lot in advance for any guidance and help. Hi, Raman, thanks a lot. But my question is the unknown member in cubes is just added by the system automatically Since ...Show All

• Len Miller SSIS integration with Cruise Control

  Hi, Has anyone tried continuous integration with SSIS TIN, Anand What's continuous integration Thanks Anand, interesting stuff. I haven't got experience of this however have experience of Agile Scrum which is another form of Extreme programming. On the specific subject of automated builds - I believe Visual Studio can assist with this. -Jamie Jamie, Please visit this site for more information: h ...Show All

• laue I can't show a calculated member

  I need to show a calculated member in a report. Reports works fine with calculated measures, but when you try to use a calculated member then raises an error which says The following system error ocurred. Invalid procedure call or argument. Any ideas Can I use calculated members I'm using RS 2005 April CTP. Thanks in advance. On your point #3, our cubes are constructed the same way. I was able to solv ...Show All

• Soroush Atarod Can't uninstall or reinstall nonfunctioning sql server

  In previous post in the Getting Started section, I discussed problems trying to run queries on multiple databases: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=299240#299240&SiteID=1 Nobody could help with the problem. I eventually got a query to run after several attempts at deleting and recreating databases. Then, I was hit with the following error message: Class does not support aggregation (or class object is remote) (E ...Show All

• Spinnerdog How can you change the isolation level for SSIS transactions

  Hello, I have a transaction running over a data-flow. My source uses a proprietary OLE DB Provider and when I run the data-flow i get the following error: The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D008 "The requested isolation level is not valid or supported.".  What isolation level does SSIS use Is it possible to change it I had hoped the answer to these questions would be ...Show All

• Ahussain SQL Express with Advanced Services - what Reporting Features does it have?

  I work for an ISV, and some of our customers use SQL Server, others use SQL Server Express. I need to develop some reports, so I was happy to read that SQL Express with Advanced Services would have some (limited ) Reporting Services available. Unfortunately, the sign-up period to beta test appears to be over, and so I am left wondering exactly what functions will be available. Is there anyone out there who has played around with the beta version ...Show All

• Manoj Kumbhar AdomdConnection.GetSchemaDataSet - using restrictions

  I'm attempting to use AdomdConnection.GetSchemaDataSet to see what information is in the AdomdSchemaGuid.PartitionStat dataset. I am setting the restrictions parameter to null. The error I get is "Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException : XML for Analysis parser: The DATABASE_NAME restriction is required but is missing from the request." All well and good, except that I can't see in the documentatio ...Show All

• Allan Stirrett How to create report using WebService as DataSource.

  Hi, We created a simple web serivce having a Web Method which accepts a string parameter and returns "Hello World" concatenated with parameter value. We tested this web service by browsing it through IE and it was working fine by accepting a parameter and displaying the "Hello World " concated with the value given through the parameter when clicked on "Invoke" button. We now created a Reporting Services 2005 project using BI having a report for ...Show All

• theprogrammer Writting multiple rows from one input Row

  Hi: I'm trying to write a transformation script to write multiple rows from 1 input row. In SQL Server 2000 DTS I could do this by using DTSTransformStat_SkipFetch and DTSTransformStat_SkipRow. In SQL server 2005 it looks like I need to use EndOfRowset but I do not know how to use it for sure. If this correct can someone show me a code example and if I am incorrect can someone tell me how to do this Thanks Phil026 wrot ...Show All

• TazmanianDevil New Login with Trusted Connection

  I have my development machine connected to my SQL 2000 server using trusted connection. I want to setup another machine for testing purposes. How do I setup SQL for another user   I can't get pass the Domain, when I setup a new login using trusted connection.  It only shows the admin and my account on the sql server machine. Once that is completed, how to I setup a w2k pc for trusted connection Thanks, MikeD ...Show All

• Mohammad Iqubal - MSFT Pivoting large result sets

  Heres the scenario: We have a database that stores values for different characteristics taken at different times. The data is stored in the following format: POSTED_UTS CHAR_ID RESULT_VALUE_FLOAT 2005-08-09 14:30:03.907 1859 1.08 2005-08-09 14:30:03.907 1860 1.07 2005-08-09 14:30:03.937 1861 0.01 2005-08-09 14:30:03.937 1859 0.01 2005-08-09 14:30:03.937 1860 ...Show All

• Gk Datatype conversion strangeness

  Hi all, After more headbanging and cursing than an entire Metallica audience, I have finally deduced how to store and calculate the values of a stack storing RPN calculations using a recursive stored procedure. But there is a new conundrum. Originally, to test the above, I was using fairly simple values -- 10, 20, +, 3, /, etc. But the real data is likely to include values with at least a couple of decimal places -- these have been configured us ...Show All

• Erfan generate a strong name key file

  I am a Newbie to programming and databases and would like to create a simple program for doing full text searching on a SQL database. I have downloaded and installed Visual Basic 2005 Express, Web Developer 2005 Express, and SQL Server 2005 Express. I have watched several hours of video tutorials and done numerous tutorials. I feel I am making progress and having a lot of fun. My machine is running XP home edition. I have fo ...Show All

• ark which algorithm to be used with symmetric keys

  Hi, I want to create a symmetric key that will be encrypted by certificate key. Can u guide me which algorithm is best out of the following: DES, TRIPLE_DES, RC2, RC4, RC4_128, DESX, AES_128, AES_192, AES_256. I tried using AES_128, AES_192, AES_256 but it says ' the algorithm specified for the key are not available in this installation of Windows.' Pls tell me which else algorithm is best to us ...Show All