Answer Questions

• Zubair Masoodi Cant upload report (rdl-file) in Reporting Services 2005

  When uploading a report definition file in Report Manager I get following error: An unexpected error occurred while compiling expressions. Native compiler return value: ‘[BC2000] compiler initialization failed unexpectedly: Project already has a reference to assembly System. A second reference to 'C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll' cannot be added.’. (rsUnexpectedCompilerError)    Any suggestions   Thanks. Your advice was what I wanted to achieve. I just didn't get there until clicking the elipsis and making a choice, then it work. TYL. Sure do appreciate all your help. Thanks for your feedback! I don't have any custom code in the r ...Show All

• kblackwell Error description

  I want to club the ErrorDescription system variable property in OnError. And I want to send this whole ErrorDescription variable on onTaskFailed. Can you please suggest how to club this errordescription on OnError event In the data flow, you can use a script component to grab the description: Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Imports Microsoft.SqlServer.Dts.Runtime.Wrapper Public Class ScriptMain Inherits UserComponent Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer) 'Use the incoming error number as a parameter to GetErrorDescription Row.ErrorDescription = ComponentMetaData.GetErrorDescr ...Show All

• Luis Esteban Valencia MCP. Exec SQL Task (stored procedures)

  Hi, Can anyone tell me how to pass parameters from one exec sql task to other ... (I used stored proc in 1st exec sql task) and passed input parameter (default value set using a variable A) and stored the output parameter value in another variable B. In the 2nd exec sql task , I passed the output param ( value of B) and doing insert into table xyz... I get errors (in passing int and string values) . I tried using ole-db as well as ado.net. Kindly give sample example. Thanks, The approach you are using sounds right to me. Could you post the details (including connection manager type) of the 2 execute sql task and the error you get . ...Show All

• GS80 Any one help me out!

  Hi I have a requirement in SSRS where in i need to generate a report in which initially there will be one record (say, a manager of a department and some values corresponding to him ) now i need to provide a drill-down on this employee(mamager) such that the next level of employees reporting to him should be displayed with all the parameters and this has to continue till the leaf level employee. Thanks in advance. ok, I'll ask the question again. In format does the data come back What are the columns is it employee_id, manager_id (where manager _id is the employee_id of the manager) OR is it employee_level_1_id, employee_level_2_id, employee_level_3_id,...... The latter is ...Show All

• programmer01 Change case sensitive database to case-insensitive

  I recently downloaded and attached the AdventureWorks sample database and it's using a case-sensitive collation (Latin1_General_CS_AS). I thought I could change it like this: USE master GO ALTER DATABASE AdventureWorks COLLATE SQL_Latin1_General_CP1_CI_AS GO but it doesn't let me (several messages that objects are dependent on database collation and one at the end telling me it can't be set to SQL_Latin1_General_CP1_CI_AS ). Is there an easy way (or any way) to do this Thanks, Dave What was the error message you get when you are trying I get several (about 25) of these for different objects: Msg 5075, Level 16, State 1, Line 2 The object 'CK_ProductReview_ ...Show All

• N_John Dynamic report with several datasources

  Hello, I am currently working with SQL 2005 Reporting Services and MS Visual studio 2005. In my SQL server I have data about organizations, so that each organization's data is stored in an individual database. In addition, the number of organizations/databases is variable. I know the number of organizations and the name of each one (that it agrees with the name of its database) because there is a database (organizationsDB) with a table (organizationsTB) containing the list of the organizations. So, It would be possible to create a report containing a summary of each organization .... for example a table in which each row contains data of each organization. Could you give me any ideas Thanks in advance! ...Show All

• TigerPhoenix 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 Jegan, Have a look at the "slowly changing dimension" data flow transformation element. It does exactly what you need. Here is what you need to set in each page of the wizard: In the first page you will need to set c1,c2, etc ...Show All

• IanBlackburn ssis dinamic build variable

  hi, i have a global variable that is a file dir param lets say: d:\input\2006_07_18.bcp. this param supposed to be built from other 3 params i.e: day, month and year. how do i build it dinamically i need the exact syntax. i have already put the filedir param as an evaluated expression but when i try to do somthing like: @[User::Filename] + @[day] + @[month] + @[year] i get an error, although i succeed in putting only one param at its expression i.e: @[user:filename]. the question is how do i build the parameter that will b built from these 3 params in its expression. Brian, i will b happy to hear from you in regard. thx, Tomer That'll have to be a concatenation when you do the cas ...Show All

• Chicomaravilha regedt32.exe

  if you're using win2000 do what the guy said to do. Don't use the regedit, use regedt32.exe. then copy the numbers of the last messages and place them in the correct place. You're absolutely right! This should have been a replay to http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=356308&SiteID=1 . Hi Justin It seems like you had opened a new thread rather than repling any current one Regards ...Show All

• tasleemarif Reporting available in SQL Server 2000 or not?

  Reporting available in SQL Server 2000 or not SQL Server 2000 Reporting Services is a additional component.Your can download trial edition of SQL Server 2000 Reporting Services here . ...Show All

• Daffodils Sql Server 2005 not starting

  Hi,       I have my web application with backend  as Sql Server 2005 CTP(Yukon). Initially It works well. I updated some security settings to the OS Windows Server 2003 and restarted the machine. Now the Sql Server is not starting.When I manually started  It logs error as follows. 2005-10-13 03:39:57.85 Server      UpdateUptimeRegKey: Operating system error 5(Access is denied.) encountered. 2005-10-13 03:39:57.85 Server      Registry startup parameters: 2005-10-13 03:39:57.85 Server        -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf 2005-10-13 03:39:57.85 Server     ...Show All

• NickGetz Best way to connect from VB6

  I'm currently working on a project that is going to read/write lot of data into a SQL EXPRESS 2005. What is  BEST WAY(faster and reliable)  for connecting, reading, writing updating from VB6... The code below  is working except the RecordCount that always returns -1 I've tried to do a Movelast before, doing so produce this error --> rowset does not support fetching backward Private ObjConn As New ADODB.Connection Private ObjRS As New ADODB.Recordset ... in a function.... Dim i As Integer, j As Integer With ObjConn     .ConnectionTimeout = 30     .CommandTimeout = 30     .Provider = "SQLOLEDB"     .ConnectionString = "Driver={SQL Native C ...Show All

• Srikanth.P SQL 2005 backup to a different server

  I have a SQL 2005 database server. I need to create a database maintenance plan that backs up to a different server. Currently, I can see the C and D drives on my database server, but not any other drives - even the ones I am mapped to. In SQL 2000, I use to enter/type in the mapping, but when I enter the mapping in my database maintenance plan, the database backups are not working. I am not getting any error message. When I execute the maintenance plan, it just checks off the steps and ends with success. It only takes about a couple of seconds for the plan to finish with the success notice. I have added sqlserviceacct to my other server's administrators group, and it has full permissions on the other server also. How would ...Show All

• Bill YU How to create table from a view

  Dear all, Can I create a table from a view like Oracle The syntax is something like as the below. create table table1 as select * from view1; Thanks you can perform a bulk insert of a single row and then delete it select top 1 * into table1 from view1 delete from table1 or you can use something like this select top 1 * into table1 from view1 where 1 = 2 ...Show All

• TiwariPradeep Facts with infinite measures

  Hello! I was wondering if there exists convenient ways to handel infinite measures in SSAS. In my exmple there are facts describing software licenses. Normally, licenses grant the right for a specific amount of installations. However, as for something like a site or enterprise license, the allowed number of installations is unlimited. Of course this can workarounded by a separate measure counting those unlimited licenses but it adds more complexity and inconveniance to analysis. Thanks in advance for ideas, Regards, Alex Sorry - but I couldn't understand from your description what exactly you need, and what would "infinite measures" solve. Hello Mosha, I will do my very best to make it more clear. ...Show All