Answer Questions

• ved_30 Report with 2 datasources

  Which is what I DONT want however somehow this one report creates two datasource controls when attaching the report to a reportviewer. I would hunt down in the report itself however I cant seem to find where that "schema" would be found that makes the report think it needs or has to datasets on it. HELP! ...Show All

• sunbeachfun SQL Server 2005 - Endpoints, how do I get client’s IP?

  Hi! I have a endpoint/Webservice configured on a SQL Server. And have made a stored procedure for it with use of “ EXTERNAL NAME” to an Assemblie. The Assemblie has been registertd on the Sql Server. My Question is, how do I get the IP address of the user(s) that uses this endpoint/WebService Can I use something like: “IP = Context.Request.ServerVariables( "REMOTE_ADDR" )” in the Assemblie on the Sql Server Any comments are very appreciated -pf One way to do it would be to use the column client_net_address in the dynamic management view sys.dm_exec_connections for the endpoint_id of interest. Look up http://msdn2.microsoft.com/en-us/library/ms181509.aspx for information on this view and ht ...Show All

• mattman206 Confidence interval

  Hi, did anybody already build some MDX to calculate the "confidence interval" I'm not very good in statistics but a customer wants this kind of KPI... Thanks, ...Show All

• elittle27 SQL 2005 Mobile vs .NET CF 2.0 SP1?

  Hi. I'd like to try a hand at SQL 2005 Mobile. I've installed sqlce30.ppc.wce5.armv4i.CAB on an HP iPaq 1950 Pocket PC, provided by the Microsoft SQL Server 2005 Mobile Edition Device SDK, http://www.microsoft.com/downloads/details.aspx FamilyId=5BD8ABAA-5813-4DB3-B23A-24551DE2ECC1&displaylang=en When I tried to interact with it, I got an error message that the .NET Compact Framework 2.0 was missing on the pocket PC. So I installed the .NET CF v2.0 SP1 found at http://www.microsoft.com/downloads/details.aspx familyid=0c1b0a88-59e2-4eba-a70e-4cd851c5fcc4&displaylang=en and it updated both the local machine and the Pocket PC. However, now when I use my local SSMS to talk to the SQL Server Mobile Engine, I keep getting the ...Show All

• Sam_2 VS2005 and C# Windows application

  I am working on a windows application (C#) that utilizes ODBC to acces paradox tables (works fine thought this would be the problem database) and a WinMobile database(.sdf) in order to sync table records. What I need to do is copy the .sdf file from the winmobile device then access it with this application to check for changed records on the PC and in the mobile database then copy it back to the mobile device via RAPI. The program compiles fine but when I try to run the application I get this error. Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) . I have already copied the System.Data.SqlServerCe.dll to my projects bin folder and then added a reference to it in the ...Show All

• Edward Smeathers Encryption Question - Urgent!

  Hi, I encrypt a column in a table.  I am able to decrypt/encrypt the same successfully.  However, when I copy the encrypted data to a new database and try to decrypt using the same certificate, it doesn't work.  I have created the same "Master Key" and certificates on the new DB .... So, is it possible to decrypt the encrypted data that is transferred from one DB to another   If not, are there any alternatives I have tried opening the master key on the new DB using the following: OPEN MASTER KEY DECRYPTION BY PASSWORD = 'pwd'; ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY; CLOSE MASTER KEY; Thanks.! Thanks for the details. The reason why you cannot ...Show All

• Punch SSIS - Handling different types of record in same flat file source

  Hi, I've just started looking at SSIS and have encountered what should hopefully be a simple problem to solve. I have a pipe-separated source file that looks like this (I've added Line numbers for simplicity): Ln 01: HDR|FEED_CODE|31-MAR-2006 Ln 02: Tom|100|Jones|ZZ1 1ZZ|USA Ln 03: Tom|200|Singer| Ln 04: Tom|305||Red|Porche ||Lanzarote |Apple|Carrot| | | Ln 05: Dick|100|Van Dyke|ZZ1 1ZZ|USA Ln 06: Dick|200|Actor| Ln 07: Dick|305||Blue|Ford||California |Tomato | |||Beef Ln 08: Harry|100|Houdini|ZZ1 1ZZ|GBR Ln 09: Harry|200|Escapologist| Ln 10: Harryk|305| |Green ||Triumph |Poland|Banana|Sprout| | | Ln 11: TRL|9 In addition to a header and footer records, this file contains three record types for each person. Record types a ...Show All

• fatihbil Programmatically Data Conversion component creation

  Hi there, I have created a package which simply imports data from a flat file to a SQL Server table. But I need to incorporate a data conversion component by which I may change the source-destination column mapping programmatically. So what I thought that I need to add a data conversion component into the dataflow task. After adding this component (I found its component id as {C3BF62C8-7C5C-4F85-83C3-E0B6F6BE267C} ) I have created a path which establishes the mapping between output columns of source component and the input columns of data conversion component. Now I am not sure how to establish the mapping between the data conversion component’s input column collection and output column collection. I am giving my code snippet her ...Show All

• GMS0012 Grouping by Age

  I have a table Age and need to create Report by Grouping Salesfigures according to Age. I put the following expression into Grouping and Sorting Properties/General/Filter /Sorting Expression... as well as in Textbox Properties/ values.. =IIF(Fields!Age.Value < 16, "<16",IIF(Fields!Age.Value <21,"16-20") Errormessage: Value expression for textbox "Age" error: Argument not specified for parameter 'FalsePart' of 'Public function IIF(Expression as Boolean, TruePart as Object, Falsepart As Object) As Object'. Question 2 . How to return Month as January, February... In correct order "DATENAME(mm, Sales.time) AS Month" (Ascending ) returns starting with April, August... DATEPART(mm, Sales.time) AS ...Show All

• Rick Casey yyyymmdd text data into a datetime field in SQL Server?

  Hello, I have an Excel spreadsheet that contains 100,000 + rows of data. Two of the columns in the spreadsheet are date fields that are sent over in the yyyymmdd format (no separators such as "-" or "/"). I tried converting these fields into dates using the Data Conversion task in SSIS. This doesn't work as it appears that SSIS cannot map a string in the format of yyyymmdd to a valid date. In lieu of this, I have added a Script Component to my transformation which can take the string and convert it to a date value using some Substring() calls on the source yyyymmdd string. A few questions for the group ... 1. Is this there a more efficient or "better" way of performing this transformation 2. I can ...Show All

• neilandalex Delete question

  I recently uploaded my old MSAccess database structure/information to the SQLExpress 2005 database. I now need to clean out the data of each table so i can repopulate it with the program i am trying to debug. The problem i am encountering is the same no matter what i do. I think it is just some sort of typo when it comes to the statment, but i am so new to Server that i am not sure. Table: OwnerInfo - fully populated/created SQL Statment: Select * From OwnerInfo SQL Error: Msg 208, Level 16, State 1, Line 1 Invalid object name 'OwnerInfo'. SQL Statment: Delete From OwnerInfo SQL Error: Msg 208, Level 16, State 1, Line 1 Invalid object name 'OwnerInfo'. Am i mistyping the table name or forgetting some sort of punctuation I have tried ( ), [ ...Show All

• herbj&amp;#246;rn Dimension Writeback

  I am interested in using the Dimension Writeback feature to solve a specific problem in a forecasting application. I only need to Update attribute values on existing dimension members, I don't need to insert or delete members. Looking at various resources on the web, I think I understand the following ... - I must be using the Enterprise version of SQL Server / SSAS - I need to write enable the relevant dimension from within my development environment - My users need to be using an OLAP Client which supports dimension writeback. Some questions ... - Is my understanding above correct - Do the following OLAP clients support dimension writeback --- Excel 2007 Pivot Tables --- Excel Services running within Sharepoint 2007 --- If n ...Show All

• rwerner prevent matrix rowgroup subtotals in excel export

  I have a matrix report that allows for the expanding/collapsing of the various row group levels. It is setup with 3 rowgroups and 1 column group. Date Customer EmployeeTitle Employee Sum(Hours) The Employee group's visibility is toggled by the EmployeeTitle group. Everything works as expected until I export to Excel. In Excel, a subtotal row is inserted for every group. I did not manually create the subtotal row and it is not displayed when viewing the report in the browser. Any suggestions on how to prevent the subtotal row from magically appearing in the Excel export Not yet... I'm hoping to convince my business that the subtotal row is a useful "feature ...Show All

• lukeliu Connect To Oracle 64 Bit using SQL Server 2005 64 Bit

  I'm using SQL Server 2005 64 Bit and having a problem when I try to make a linked server to Oracle 10G 64 Bit (installed on the same server) from management studio. I'm using "Oracle Provider for OLE DB" to connect to Oracle 64 Bit database because it is the only provider but from what I've read in Books Online that the provider doesn't support for Oracle 64 Bit. When I’m using SSAS 2005 and try to connect to Oracle 64 Bit database, an error message appear when I’m using “Microsoft OLE DB Provider for Oracle”: Test connection failed because of an error in initializing provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are ...Show All

• James_Steven where is "Create Stored Procedure Wizard" in sql server 2005

  Does Sql Server 2005 contains "Create Stored Procedure Wizard", like we have in sql server 2000 Thanks in advance. Hi, Go throgh the following procedure... Go to --> ObjectExplorer ---------------->DataBases ------------------>Goto ur database(Ex: Pubs) -----------------------> Programmability --------------------------->Right click on Stored Procedures ------------------------------------>again Right click the Query window ------------------------------------------> select design Query in Editor... Inside SQL 2005 Management Studio, expand the database (where you want to create your stored procedure) then expand programability, then on stor ...Show All