Answer Questions

• Doug Owens Looping through an excel spreadsheet

  Being new to SSIS I wish to loop through a series of excel spreadsheets and within each workbook loop through each sheet. I am aware of the For Each container but how can the each sheet in the workbook be referenced Steve Yes, I would appreciate it spelt out as I am finding this thoroughly confusing. Will keep persevering though. Steve You need to use an ADO.NET ...Show All

• papaboom check what table are lock by application

  Dear All, Sometimes the application cannot write record into SQL Server, but the source code of this application cannot be seen. Therefore, I wanna verify the MSSQL status. I have to check what table are locked by application. I wanna know the following information. locked_table, locked_by_application, locked_status Can I write some t-sql to get the information I tried using Profiler, but it generates some useless information. Could you ...Show All

• Ffee Hundreds Of VIEWS

  What are the downsides to have many multiple views on a SQL Server Database It was somebody's design decision to create 10 views for each vendor in our database- that could range from 20 to 500 vendors ... which means we could potentially have 5000+ views in our database. What is the downside/problems with doing this Yea see- that would actually be the smart thing to do- and I would be overjoyed if I ...Show All

• saparicio Failure to run when using DTC

  Does anyone hany any experience of using SSIS with MS DTC I have a package that runs successfully. When I switch it to using transactions (i.e. TransactionOption= Required ) it fails. I get the following messages in the log: -Starting distributed transaction for this container.  -Failed to acquire connection " <connection-manager-name> ". Connection may not be configured correctly or you may not have the right permissions on this ...Show All

• James Sun Encrypted DB -- Restore Question

  Hi, I have a DB in which I encrypt a few columns in a table.  I am using a Symmetric key to encrypt and decrypt the data.  When I take a back up of this DB and restore on another server ... my decryption doesn't work.  I have dropped the master key and recreated it with same password and that didn't help either. What are the rules to follow when we restore a db on a different server that has encrypted data   Thanks. ...Show All

• 52179apb SCD Historical Component not working

  I have an SCD that contains a historical output path. If I throw dataviewer in the flow before the SCD, I can see that it should trigger a trip down that lane, but its not. In the advanced editor, all looks good. Anything I can check. BTW, the datatype of the fields that should cause the SCD are datetime. thanks in advance A collegue figured it out. Shout out to my homeboy Joe! For those who ...Show All

• filiph Analysis Services Deployment/Management Question

  I have a local server for development that is on my local domain that I can work on very easily. However, my production server is offsight and on a different domain. Since Management Studio will only allow Windows Authentication when connecting to an Analysis Services instance, how can I manage the remote cube without having to remote desktop into the production server TIA Right, you need to either TS to the ...Show All

• daveCsharp "Begins With" Filter in Report Builder?

  Hello, Anyone know how to setup a "Begins With" or "Ends With" Promptable Filter in Report Builder Thanks!! -Brian Does the Report Designer (not Report Builder) support the "Begins With" or "Ends With" filter I played a little with it last night and didn't see anything... -Brian What about creating a column with a left(columnname,1) and using the Equal to operator (Of course this would only work if you're looking for the fir ...Show All

• SilverCoin Deleting a database

  I would like to delete a database from Analysis Services from the command line, but I have been unable to find a way to accomplish this. Is there a utility or a script that can accomplish this And if you are using Analysis Services 2005, you can write this C# application based on AMO (the management object model for AS2005, successor of DSO from AS2000): (to reference AMO, use Microsoft.AnalysisServices.DLL ...Show All

• miloone a related question - how to convert from sqlexpress to sql server 2005

  how does one convert from sqlexpress (mdf files) to sql server 2005 and vise-versa, ie from SQL Server 2005 to SQLExpress mdf files What if you don't have the ldf for the SQLExpress database Look in Books Online for the usage of [ sp_attach_single_file_db] Attach & detach is the easiest way to go :-) ...Show All

• Phenix connection error

  hi, I installed sql server 2005 ,when i try to connect to sql server management studio iam getting this error. An error has occurred 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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data P ...Show All

• Ray_CA RS 2005 & Host Headers

  Does anyone know how get reporting services to work installed on the non default website. i.e. we are using host headers to split up the sites. It will work fine if /Reports is installed on the site with the host header but it seems /ReportServer must be on the default site. I tried changing the ReportServerUrl values in RSWebApplication.config to many different things and neither of them worked. Any help would be appreciated. Thanks In Advanc ...Show All

• myhanguk The Query Could not be processed. The data provider didn't supply any other error information (SSAS 2005, SharePoint, OWC 11)

  Hi, I have 2 cubes processed and deployed successfully on a 2003 server (SSAS 2005) . (I do get an attribute key error but I am turning it off using Custom Error Configuration). I am connecting to the cubes using OWC 11 pivot table viewer and OWC 11 Chart Viewer. These are deployed on a SharePoint Server Portal, which is hosted on the same server. As long as I view the sharepoint pages on the same server, the charts and tables display fine. W ...Show All

• RainerS Internal error in fresh install of reporting services

  Hi, Im having difficulty getting a report to work with SSRS for SQL server 2005.  The server configuration utility looks fine, but when i try to deploy a report, or access the site, i get: (rsInternalError) heres the log file: <Header>   <Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>   <Locale>en-US</Locale>   <TimeZone>New Zealand Daylight Time</Time ...Show All

• eXavier View Modify in Server Management Studio

  In Server Management Studio, when you right click on a view and select Modify , you get four windows on the right side in a vertical stack. The top is the view diagram. The second one down is the grid where the view design elements are listed, i.e. Column, Alias, Table, Output,... . The Output column is a check box and, if the design element is written to the view's output, there's a check in the box. When I look as some views, the very bo ...Show All