Answer Questions

• YeeBoon Insert or Update SSIS for Composite Primary Key

  Hi , We have scenario like this .the source table have composite primary key columns c1,c2,c3,c4.c5,c6 .when we move the records to destination .we have to check columns (c1+ c2 + c3 + c4 + c5 + c6) combination exist in the destination. if the combination exist then we should do a update else we need to do a Insert . how to achive this .we have tryed useing conditional split which is working only for a single Primary key . can any one help us . Jegan.T Hi Peter , Thanks for the suggestion .but my source table does not have surrogate key. Jegan Hi Jegan, Have a look at the "slowly changing dimension" data flow transformation element. It does exa ...Show All

• guilhermecvm94558 Giving permission to view CERTAIN records

  I've been looking through permissions to see if it's possible to grant a user permission to see only certain records from a table. For example: I'm granting users to view records in the table 'Sales', but I only want the users to see their respective data. User A should only be able to see Sales where Sales.Location = 1 User B should only be able to see Sales where Sales.Location = 2 ... and so on. I believe I've read this is possible, but in looking through the permissions you can define, I've only found where you can limit the columns a user sees, not records. Anyone have any ideas or did I just remember something wrong You might try something like this: create table Account ...Show All

• tamorgen OLE Db Source and Variables

  I created a OLE DB Source, and created a sql command text. The issue is with parameters, I have to use the ' ' to identify. What if I have multiple variables of the same type scatter around, how can I define that Somthing like this would be good... Declare @month set @month = select blah,@month where month=@month or How could I use the ADO Syntax and just put @month Thanks, Mardo another solution would be to use variables and expressions to dynamically create the sql statement. Execuse my ignorance but I only see a OLE DB Data Flow Source. I understand that ADO.NET can used name paramters but I can only seem to use that in Data Flow Destinations. Marty Guys, my apologies for being a bit misleading. The .NET conn ...Show All

• chanmy8 Grandtotal row diff between analytic and regular aggregate functions?

  Hi, Assume there is no sale with over 2000 units, the first query returns no row while the latter returns 1 row with a null value. I am not questioning the result, I would like to understand conceptually what semantic difference between the Sql99 analytic function and regular aggregate function makes the result different in this case. select sum(Quantity) over() from orderdetails where Quantity > 2000 select sum(Quantity) from orderdetails where Quantity > 2000 thanks in advance, Jeopardy over() 1.Fetch the Rowset (if there is no row to fetch the Rowset is empty) 2.Apply the order/partition on the Rowset (if there is no row to fetch the Rowset is empty) 3.Apply the aggregate function ...Show All

• Zirc COM objects under 64-bit?

  Hi everyone,   Primary platform is Framework 2.0 under 32-bit Production platform will be Framework 2.0 under 64-bit.   I'm concerned about what object should I use in order to launch DTS 2000/7.0 from our .Net service.   Currently it tested fine from a 32-bit environment (sql server 2005 as backend).   Reference: "Microsoft DTSPackage Object Library" Physical file:  dtspkg.dll   My wonder,   is there any limitation when it's gonna to work on 64-bit   Generally speaking, any limitation/issue/drawback for COM objects under 64 bit In my project properties appears Any CPU, x86, x64. I've got now Any CPU.   Thanks for your advices,   ...Show All

• Sapna call store procedure from another store procedure

  I know I can call store procedure from store procedure but i want to take the value that the store procedure returned and to use it: I want to create a table and to insert the result of the store procedure to it. This is the code: Pay attention to the underlined sentence! ALTER PROCEDURE [dbo] . [test] AS BEGIN SET NOCOUNT ON ; DROP TABLE tbl1 CREATE TABLE tbl1 ( first_name int , last_name nvarchar ( 10 ) ) INSERT INTO tbl1 ( first_name , last_name ) VALUES ( exec total_cash '8/12/2006 12:00:00 AM' '8/12/2006 12:00:00 AM' 'gilad' , 'cohen' ) END PLEASE HELP!!!! and God will repay you in kind! Thanks! He told me error: "Incorrect ...Show All

• kru Rendering Reports with IE7

  Ever since I have installed IE7 I keep getting prompted to log in several times. It seems to work fine with IE6. Any help would be great Thanks Will Do you see a status band on the top of the page prompting to enable Intranet settings ...Show All

• P-Vincent Belisle SQL Server 2000 Virtualization

  I'm looking for information on running SQL Server 2000 on virtual servers. Has anybody tried this What is Microsoft's position Any information is appreciated. Thank you PCL With the right hardware and virtualization platform, SQL Server will work great-even with a heavy transactional database. And there are some very large corporations that do run their SQL and Oracle databases in a virtual environment. But it requires some good configurations and a good investment of money. Here's what you have to do: Obviously, do not use a hosted virtual platform, i.e. Parallels, VMware Server, Virtual Server, etc. These are for dev and tests and for small companies or a small department server. You need real muscle to ...Show All

• Rahul Saxena Detailed description on creating a dynamic excel file

  Is it possible that i can create a dynamic excel file (destination) ex, i want to create a Dyanamic Excel destination file with a filename base on the date this will run on jobs. Is this possible 11172006.xls, 11182006.xls Sure. With just about any destination, including Excel, the name/location can be dynamic. 1. Create a string variable which represents the excel file name, set the variable's EvaluateAsExpression property to true, and set the expression to something dynamic, for example: "ExcelTarget" + (DT_WSTR,4)DATEPART("yyyy",GETDATE()) + ".xls" 2. For your excel connection manager, in the expressions node of the Properties tab, set the connection string ...Show All

• Ross B. SP1 Hotfix 919478

  I have SP1 on most of my servers. My users however do not. They have been developing using "select all" and are now ready to deploy a major project, I am in the process of installing the hotfix so my question is "they do not have SP1 and I have SP1 along with the hotfix" will that work or does this hot fix require that the client tools have SP1 and the hotfix applied as well" They do not want to change their development environment since they are so close to deployment of their reports. Thank you!! It is not required to install the hotfixes in the development environments, unless you really want to be able to get the same 'select all' behavior, etc. when developing the reports. Report designer in BI Deve ...Show All

• http://www.ilkon.com Error when deploying forms authentication sample

  Hello I'm trying to get the forms authentication sample working - I have followed the instructions given in the ReadMe that came with the samples. When I try to browse to localhost/reportserver (on the server), instead of seeing the logon page as expected, I get the following error message: An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. ...Show All

• Duncan McC US Date Format in Calender Parameter (SRS2005)

  Hi this is driving me completely mad. UK based so we want the calendar parameter to display the date format as dd/MM/yyyy rather than MM/dd/YYYY. I'm using SQL RS 2005 on a Windows 2003 sp1 box. I've used regedit to look at all the user account international settings, all of which are set to UK. If i log on to the box and run the report the server the date format in the calendar parameter display correctly. Same account on annother machine displays it in the US format. I've also checked my regional settings on the other machine and it shows UK. Where else is it going to pick up the US format from Right click on the reportserver virtual directory in IIS and go into the ASP.NET tab. There are culture set ...Show All

• jchohio export OLAP in SSAS 2005 to excel pivot table

  Hi genius, Nice to meet you here! When developing BI programs with SQL Server 2005, I got this problem: Users want the report should be exported in office excel 2003 format, and stored in PIVOT TABLE. We have decided to use OLAP tech in SSAS(SQL Server2005 Analysis Services) to generate cubes. If we just use excel as a client tool, and create a pivot table which connects to the cube database, it's ok. But, the users want to download the excel file from a web page, further more , they want to filter the data through the web page. How can I do Is there any other component needed Help inline. Thank you! Thank you very much. You really point out a way for me:) Another question: If I ...Show All

• Roxy1980 Import Data to SQL server from Excel spreadsheet

  Hi all, Firstly, i'm new to integration services and have only done a little with DTS jobs. I'm trying to create an integration services project which will import data from an two worksheets in an Excel spreadsheet to two different tables in a database. I'm looking at only one table at present to make things a little more understandable. One stipulation i have is that i need to be able to specify a variable value and insert that as an additional column in the database. I have and Excel source and a SQL destination both of which have been set up with there specific connection managers. I also have a variable which i add in using the derived column task. When i try to debug this i am getting a few problems. I think these may be to do with th ...Show All

• wva Report Builder and NULL values

  Hi, I am trying to create a report with Report Builder, using a simple data model residing on SQL2005 reporting server. The problem that literally drives me crazy is that I can't find any way to handle NULL values in my report. Say, a table has 3 numeric columns, and I need to create a formula to make a sum of those 3 columns. This would be an ordinary sum for the same entity, not an aggregate. So I create a new formula with following body: Field1 + Field2 + Field3 The problem is, each one of the 3 columns can have NULL values, and if any column actually is NULL, I end up with empty sum value, instead of having sum of those columns that do have values. What I need is one of the following: - a way to check for NULL values ...Show All