Answer Questions

• museicon SSIS Deployment and Removal issues

  I created a setup package and installed it on my SQL2005 server. I cant seem to find anywhere on the server where they are installed, but I can access them from the Job schedule tool, which work for me. However, now I have to upgrade the deployed SSIS and I cant seem to install on top of an existing one (gave me no errors but after testing it i realized it is still running the old version.) My questions are: 1) How can I find and delete these SSIS packages from the server 2) How can I just upgrade for a new version of a SSIS package I need to be able to do both things as at some point I may want to just remove some packages. That fixed it, thank you! Are you using a ...Show All

• sqldummy Experts Pleeease advice Run WWW service in IIS 5.0 isolation mode on wk3 server

  On windows 2003 server i am having a problem, when i call reports 2005 from vs 2003(asp 1.1) it presents an error saying IIS cannot run two different version under one process. (because of 1.1 and 2.0 version conflict) only happens on windows 2003 server. now would like to change the iis to allow www to run on iis 5.0 isolation mode that way it uses aspnet_wp.exe process. which will allow multiple versions under one process mode. But has any one tried this or not , i tried internally on our windows 2003 server which is in our network and it works fine. Please share your thoughts, since i would like to take the same approach with our hosting server which is on intenet. Thank you all for sharing your opinions. ...Show All

• PhrankBooth Configuring merge replication for side-by-side SQL Server 2000 and 2005

  I am trying to migrate from my current system, where I do merge replication from Windows Mobile devices running SQL Server CE 2.0 to a central database running SQL Server 2000 sp3a. I want eventually to move to a system running SQL Server 2005 CE replicating to a SQL Server 2005 back-end. But the transition will need to be gradual, and I may have to support both systems for a while until I can convert all clients from the old system to the new. I also need to do thorough testing. So ... I'm trying to set up a test environment giving me the maximum possible flexibility to do my testing. Ideally, I'd like to set up SQL Server 2000 and SQL Server 2005 on a side-by-side basis, in a manner that would potentially allow mobile devices running ...Show All

• stenis Using XML variable as a table

  Hi All, Using SQL2005, I'm trying to improve the performance of some code that is currently using: OPENXML, sp_xml_preparedocument and sp_xml_removedocument. -----------------------code----------------------------------- set nocount on declare @X xml declare @docHandle int set @X = '<ProductInformationEnhancementsDS> <ProductInformationEnhancements CatalogueItemID="100-0007"> <PriceCheck RetailerName="CompanyA" RetailerPrice="19.9900" RetailerPriceCheckDate="2006-06-17T00:00:00" /> <PriceCheck RetailerName="CompanyB" RetailerPrice="18.9900" RetailerPriceCheckDate="2006-06-17T00:00:00" /> <PriceCheck Ret ...Show All

• MLansdaal Debugging a Calculated Measure

  Is there any practical way to find out a problem with a calculated measure The one I have created is obviously wrong (I get a #value! in the cells), but other than that I get no details telling me where I am going wrong. Other than make changes and process the whole cube again I cannot think of how I can get to the root of it. You can try using the built-in calculation debugging facilities within BIDS. In the Calculations tab for the cube, view the calculations in script view and add a breakpoint for the calculation in question. Then, on the Debug menu, select Start Debugging. That will open a browser within the calculations tab that will allow you to "step" through the calculations... Th ...Show All

• bmarcus Dimension won't add to cube??

  Hi, I built a new dimension with the dimension wizard while working with a cube that has dimensions pre-exisiting. The relationship is defined and I don't see anything different about it when I look at the other dimensions. However, when I look at the cube editor, all of the other related dimension tables are blue and the fact is yellow, but this table is white. Then I process the cube and it's doesn't show up in the cube browser as a dimension. It's like it doesn't exist!!! How can I add a new dimension so that it's visible AND usable Also, how do I create shared dimensions or make private dimensions shared THanks in advance. Mike mreese@satorigroupinc which version of SSAS r u using I figured it out. When you ...Show All

• Jman Killer Connection Timeout when processing cube

  I am getting a connection timeout error when processing a cube with measure group containing 4mil rows or so. It errors after 5 mins and after about 3mil rows have been read so it's probably not the ExternalCommandTimeout issue. The Fact table for the measure group is created using a named query. I would appreciate any insight into why the error is thrown after 5 mins. Here's part of the error: =================================== The connection was lost. Close all processing dialog boxes and try processing the object again. (Microsoft Visual Studio) =================================== The connection either timed out or was lost. (Microsoft.AnalysisServices) ------------------------------ Program Location: at Microsoft.An ...Show All

• LexYW Integrated Security doesn't work - "Not associated with a trusted SQL Server connection." Error

    Hi, I have a piece of Java code that needs to connect to SQL 2000 (SP4) using Windows Authentication. It's running on Windows Server 2003 SP1. I tried JDBC v1.1 and followed the code from the following blog: http://blogs.msdn.com/angelsb/default.aspx p=1 But still get this error as shown below. Any help appreciated. I am using JDK1.4.2, "sqljdbc_auth.dll" is located under "E:\SQL2005JDBCDrv\sqljdbc_1.1\enu\auth\x86", also made a copy under "E:\JavaTest" and "C:\Windows\System32" but still won't work. Cheers Allan   =========================================================== E:\JavaTest>javac -classpath ".;E:\JavaTest\sqljdbc.jar" TestW2.java E:\JavaTest>java -classpath ".;E:\JavaTest\sq ...Show All

• Attila Fogel Querying SSAS within SSIS

  Hello, Can anyone tell me how can i make a query to a ssas cube using ssis I have the following query SELECT { [Measures].[Saldo] } ON COLUMNS , { { { DESCENDANTS( [Empresa].[Tipo Empresa].&[0], [Empresa].[Empresa] ) } * { [Tempo].[Ano].[2005].&[2005H1].&[2005Q1].&[2005M01] } * { DESCENDANTS([POC].&[321],,leaves) } * { DESCENDANTS([Estrutura].&[CA00CA],,leaves) } } } ON ROWS FROM [Balancete] I put it in a ole db source, the source is a analysis 9.0 connection. But once i run the dts i got the following errors. [OLE DB Source [9244]] Error: Cannot create an OLE DB accessor. Verify that the column metadata is valid. [DTS.Pipeline] Error: component "OLE DB Source" (9244) failed the pre-e ...Show All

• Altoids CRLF in an expression?

  I am building an expression and have poked all around on how to do a CRLF It is probably so easy that I am just missing something obvious. ThnQ David Frommer wrote: use "\r\n" For those that don't know, this solution uses SSIS expression literals. Here's where SSIS shows its immaturity... Try: replicate(CHAR(13),1) + replicate(CHAR(10),1) Here's where SSIS shows its immaturity...  Just like my son!!! Ha, I was looking for a ASCII() or somthing. Thank you sir! use "\r\n" Thanks Phil, I supposed the same ...however, "the function CHAR is not recognized" error came up so I am assuming that I ...Show All

• Petknep SELECT DISTINCT on one column

  I know this is a popular problem, but i haven't found an answer to my situation. I have a table (myTable) with three Columns (Column1, Column2, Column3). Column1 entries are unique (with unique identifier), Column2 entries are not unique. I want to do a SELECT DISTINCT on myTable so that Column2 is unique and i get all the other columns. I thought something like this would work SELECT DISTINCT Column2 as Col2, newid() as Col1, Column3 as Col4 -- I am getting uniqueidentifier for each row as well This doesn't seem to work however. I still get all the rows because Col1 is unique. since i am using aliases, the usual syntax doesn't work either. any help would be greatly appreciated! thank you for your reply ...Show All

• CramsterRk Need Help: For Cube data in Multi Languages.

  Dear Friends.. I need help if any one can... My need is that...I am devloping my Cube using SSAS. I want to access my cube in multi languages e.g.: English, Japanese or other. At the movement I have two languages description in SQL Database like English and Japanese. But In SSAS Translations, I can translate Measures Groups, Dimensions, Perspectives, KPIs, Actions, Named Sets & Calculated Members names. But there will be a need to Map Columns as per selected Lenguage so that I can display in proper language data. Suppose I select Japanese the description should come from Column where Japanese description is stored. OR any othere method by doing I can see my reports/data in any language. Please Help... ...Show All

• David S. Anderson Backing Up and Restoring Transactional Replication

  From Help Transactional replication includes the sync with backup option, which can be set on the distribution database and the publication database: It is recommended to set this option on the distribution database in all cases. Setting this option on the distribution database ensures that transactions in the log of the publication database will not be truncated until they have been backed up at the distribution database. The distribution database can be restored to the last backup, and any missing transactions are delivered from the publication database to the distribution database; replication continues unaffected. Does database will not be truncated until they have been backed up at the distribution database mean that the d ...Show All

• Visions.net Report of Reports

  Are there any example of SSRS reports using an rdl file as the source for the report. I.e. a Report of Reports Hi Freddie, could you please elaborate a bit more thanks, 99 One way of doing this in RS 2005 is to render a report with the xml data rendering extension as xml document. This is then used as input for the xml data extension. However, getting the query setup correctly and working is a bit tricky. A specific sample and explanation for this approach will be available in an upcoming MSDN article about the RS 2005 Xml data extension later this summer. -- Robert Thanks Robert, I did find an article "Integrate XML into Your Reporting Envi ...Show All

• Augustin Calin High availability for Database Mirroring

  Hello, I would like implementing a database mirroring architecture with SQL server 2005 but i have questions. If i don't use a cluster architecture, i would like knowing if there's any solution to move the alias SQL server from the primary to the secondary by script. Anyone got a pb like me or any solution ... Thanks for your help... Lookup Database Mirroring in Books Online. Specifically look for a topic called Making the Initial Connection to a Database Mirroring Session which has the info you want. There's a good whitepaper on your problem called Database Mirroring in SQL server 2005 - see http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx I suggest you start ...Show All