Answer Questions

• Madhusudhanan P Adding Subreport Total to Main Report Total

  Hi, can anyone help I have created a Report using Visual studio-the report displays a subreport within it. On the Subjective Report I have 12 values for each month of the year. For the first month the value is =sum(Fields! Month_1.Value) , and I have named this text box ’ SubRepM1 ’ The name of the subreport is ‘ subreport1 '. On my Main Report, again I have 12 values for each month of the year. For the firs ...Show All

• arcon5 Server upgrade question

  We plan on doing an in-place upgrade of our SQL 2000 server.  It is currently on 2000 Server and the plan is to upgrade it to Server 2003.  Are there any gotchas that I have to worry about with this, or is it a stright forward upgrade with few to no faults   I'm confident that the hardware will check out OK, so it's mainly SQL that I'm concerned about. Thanks, Aron There is a new tool called Upg ...Show All

• WebZ Problem with SSIS Transaction...Transaction Scope

  Hi, I am having some problem with SSIS transaction. Eventhought I tried to imitate the concept that Jamie presented at http://www.sqlservercentral.com/columnists/jthomson/transactionsinsqlserver2005integrationservices.asp . My workflow is as followed ********************************* For Each ADO.Record in Oracle (transaction=not supported) If (Certain_Field_Value = 'A') Lookup Data in SQL DB with values from Ora ...Show All

• koolsandy Inserting large amounts of data

  Hello all, My apologies...re-posting from "SQL Data Engine" forum... I am trying to insert large amounts of data into a table using C#.NET. I create a parameterized query, and within a loop, I set each parameter's value and use ExecuteNonQuery to populate the data. Using .NET, I have only been able to achieve 1500 records per second. Using DTS, I can achieve 975,000 records in a little over a minute. I am using SqlCommand and giv ...Show All

• Francisco73 How do you edit a Group with no header or footer?

  I am new to SSRS 2005 and so far the only way I can figure out how to edit groups in a table is to right click on the group header or footer and select Edit Group. But how would you edit the group if you chose to not have a header or footer And how would you delete the group for that matter I'm looking for something like the Crystal Reports Group Expert. highlight the table (easier said that done...click any ...Show All

• MikaelN OLAP / Analysis services version checking by client

  The problem is that i would like to integrate a code to the file in net where MS Office Web Components and OLAP services are beeing used. Code should automatically detect a version of olap client and office web service components (OWC) and if newer version is needed, then it should download it. Good instructions were @ http://support.microsoft.com/default.aspx scid=kb;en-us;312876 where ptssetup.exe included all necessary informat ...Show All

• Yudesh Insert Parent Child records...

  Hello, We have a complex functionality of migrating data from a single record into multiple parent child tables. To give you an example, lets us assume that we have a single table src_orders in the source database. We have a parent Order table and a child OrderDetails table in the target database. We need to pick one row from src_orders and insert this row in the Order table, pick up its PK (which is an identity column) and then use this t ...Show All

• Nathan Lewis "...conversion between types DT_I1 and DT_I2 is not supported"

  I created a simple ragged file with 3 lines: 1 2 3 and coupled it to a Flat File Source. The Flat File Source suggested that the type was DT-I1. Next I created a “SQL Server Destination task and connected the output of the Flat File to the Sql Destination. In the Destination editor I created a table, whose one column was declared to be a sql smallint. Here’s the problem: the Sql Server Destination now disp ...Show All

• szabti PROBLEM W/ OLE DB COMMAND

  In a data I'm trying to implement an Ole DB Command to do a database table update.  When I enter my sql command I get an error saying [OLE DB COMMAND [5926]] - unable to retrieve destination columns...  It appears it doesn't recognize the table I'm trying to update, however I do have a sql task in the control flow that is successfully selecting a row from the same table that I'm trying to update (just to prove that I can access that ta ...Show All

• Thomas Irvine relocating system files

  How (if possible) can the system files (tempdb, master, model,msdb) be relocated to different locations. ie from C:\ drive to some other drive. Thanks to eveyone for being there to help. SQL server 2000 Standard SP4 Check out this article on SQLServerCentral.com ...Show All

• Waitcursor ForEach Config validation errors

  I have a Config file for a Data Flow that is utilizing a Configuration file. I have specified in the Configuration file to capture the Directory and FileSpec for the ForEach Enumeration. When I open the package, I get the following error: Warning 1 Warning loading ISOTypeLoss.dtsx: The package path referenced an object that cannot be found: "\Package\Foreach TC03 File.ForEachEnumerator.Properties[Directory]". This occurs when an attem ...Show All

• Grayfox41 ReportViewer with Authentication

  I'm new to Reporting Services but have built some reports and have implemented them.  I have used the report viewer which works great and has a great tool bar that users really like.  One problem, I can't figure out how to pass network credentials using the viewer. If I use the ReportingService class I can pass the credentials and everything is great except that I lose the nice tool bar. I want the best of both worlds without having th ...Show All

• admirm Merge join

  Hi, folks: I am now testing merge join with results not expected. I have two OLE data source (one from Oracle, one from SQLSERVER) then I do a merge join with the key LOCATION_ID OLE DATA SOURCE 1                  OLE DATA SOURCE 2 --------------------                  --------- ...Show All

• Robert Gauvin Conditional Split to send top 10, top20, and top 30 in three different flows ?

  I  have dataflow that i wish to split. The recordset that i uses is sorted by the Sort Task. After that i'll like to take the Top 10 records and send in one direction, then ill like to take the top 20 and send in another direction and finally Top 30 in a third direction. How can i do that   cgpl wrote: The easiest way to deal with that, would be if you could disable the "Random" feature in the R ...Show All

• stegus Auto Create trigger after re-initialization completed

  Hi all, Is it possible to create a trigger after creation of table during reinitialization   if so, how can I do that   Thanks in advance! That's great! By the way, I've submitted a feature request to have new publication wizard support the addition of pre/post snapshot script, this issue may be addressed in a future release of SQL Server so you configure pre/post snapshot script without needing the manual ...Show All