Answer Questions

• Mali Buda Assigning the value of variables in a Subpackage

  Hi, I have a parent SSIS package that executes various subpackages. Each of the subpackages contain variables that are required for their successful execution, e.g. one has a variable of datetime datatype and a variable of varchar datatype. This date will essentially change with every running of the package as it specifies the date that additional data has been added to the back-end SQL Server 2005 database. I can't find anything in the ...Show All

• Labutin Reporting Services 2005

  Can I install and run Reporting Services 2005 on a SQL 2000 server currenly running RS 2000 Sorry, your original message wasn't clear enough, so I thought you wanted to run SSRS 2000 and 2005 at the same time on the same machine. Evidently, you just want to upgrade. Yes, 2000 reports can be published to 2005. They will be automatically updated so they work in 2005. Once updated, you cannnot round-trip them BACK to 2000, however.   ...Show All

• WhyteKnight SAN Replication

  I'm wondering if the technology exists to use SAN replication for sql server 2005 disaster recovery. I have a bunch of prod servers I want to add to a san, I then want to have another bunch of servers at a dr site connected to another san. Is there a technolgy ( non sql ) to enable full ( real time ) san replication of the data ( for SQL Server databases ). I don't need alternate suggestions, this solution has been proposed to my client ...Show All

• rafeek how to get the sum of a group and not the whole column?

  i have no Reporting services installed on my system but in Crystal Reports, you can do this by creating a Running Total field... can you explain further any sample data with desired output will help CryptoKnight wrote: i have no Reporting services installed on my system but in Crystal Reports, you can do this by creating a Running Total field... Account Sales New John Doe 1,000,0 ...Show All

• esgibson Slow execution of queries inside transaction

  I have some VB.NET code that starts a transaction and after that executes one by one a lot of queries. Somehow, when I take out the transaction part, my queries are getting executed in around 10 min. With the transaction in place it takes me more than 30 min on one query and then I get timeout. I have checked sp_lock myprocessid and I've noticed there are a lot of exclusive locks on different objects. Using sp_who I could not see any deadloc ...Show All

• Rob C Analysis Services 2000, deleting a cube

      When I am in Analysis Manager and I try to delete a cube/dimension/database/measure by right clicking and selecting 'delete', Analysis Manager freezes up and mmc.exe uses 50 percent cpu (it stays like this forever till I 'end process').  I have tried reinstalling Analysis Services as well as Sql Server altogether but I still get the same problem whenever I try and delete something.  Any ideas ...Show All

• Avida AdventureWorksDW database

  I can not find the databases and samples for SSIS that are mentioned in the tutorial on my disks, or DVDs. Please tell me where I may get them from Installing SQL Server copies the Samples off the CD, but doesn't install them. Start > All Programs > Microsoft SQL Server 2005 > Documentation and Tutorials > Samples > Microsoft SQL Server 2005 Samples to install. Greg. ...Show All

• Judy USAM Changing Connection string in multiple packages.

  Scenario: 130 dtsx packages using 4 matching connections. 3 of those connections are stored in an SSIS Configuration table in an Operational database. The last connection is in a shared data source and points to the Operational database so the packages can grab the others. Problem: It's time for deployment and all of those connections must change to production servers. The 3 are no issue, just change the ConfiguredValue in the SSI ...Show All

• Dao about multiplication in sql

  what is the value when running sql script select cast( cast(.0000006 as numeric(38,10)) * cast(1.0 as numeric(38,10)) as numeric(38,10)) the result is .0000010000. why the result is not .0000006000 thanks for your help~ Well... speaking as someone who has just changed a whole bunch of tables, views, functions, etc. without fully appreciating that decimal (38, ...Show All

• AnonymousDeveloper74 How to Copy Objects with SQL 2005 SSIS

  The problem is this: In SQL 2000 DTS there was an option for "Copy Objects and Data Between SQL Servers". However, this option has been removed in SQL 2005 SSIS. Apparently the only way to do this in SQL 2005 is to create a .DTSX package in SQL Server Business Intelligence Developement Studio or VS 2005. You do this by creating a new Integration Service Project and using the Transfer SQL Objects Task. Within the properties of thi ...Show All

• CrazyHakiko Change image visibility based on render format or code variable value

  I have a report with a background and need to render and archive two copies of it, one for viewing(with background) and one for printing(without background). I will be doing this locally with business objects and will use the Microsoft.Reporting.WinForms library. Here's my thinking: Dim an instance of local report Set the template path Set the datasources --->Somehow set code variable for the report that it uses to set the hid ...Show All

• Javicho7 SQL Server 2005 June CTP Install Issue

  When trying to install SQL 2005 June CTP to a Windows Vista Beta 1 install I am receiving the following error during the configuration portion of the installation: TITLE: Microsoft SQL Server 2005 CTP Setup ------------------------------ SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: Connection was terminated [1236].  Refer to server ...Show All

• scottportraits PERCENTILE_CONT equivalent in MS SQL

  Hi All,   I have a table with a count of 30K rows that describe values over a period of time. I would like to be able to replicate the PERCENTILE_CONT function that is found in Oracle with MS SQL Server 2005 but have not had much success.   Would anybody know of a way to use current MS SQL syntax to retrieve the value of the 5th,10th,15th,20th etc... percentile of my table values Assume that all of the values are assoc ...Show All

• VitCon Tuning database and Index Repair job...

  Hello, I have a SQL 2005 Standard edition running on Win 2003 server. I setup a index repair and run every day - 3:00 AM. - No one uses. I recently trace a database for 8 hours saved to a file - about 2GB. Used SQL Profiler with "tuning" template - filter only the one database I wanted. and ran SQL Tuning Advisor about three days ago. Now, the progress says 7% done and still running. This server is not the fastest server bu ...Show All

• Vikram Karumbaiah Changing SSIS package - new user question

  I saved a simple export/import package from the import/export wizard to a .dtsx file/package. Now I want to change the package to delete/truncate all of the tables before adding data. (since this has 80 tables it would have been a pain to edit each of them individually) How can I easily go about doing this with the SSIS package. I can't find out where this would actually be executed. Also, how can I actually view the code behind the SSIS p ...Show All