Answer Questions

• Coder4Christ SQL Agent error - unable to read log file, the parameter is incorrect

  My SQL logs are filling up with the error "Unable to read log file, the parameter is incorrect". Seems to be related to the Sql Server Agent account. I saw one post about changing the Sql Server Agent from local user to local system but not sure how to do that - suggestions Does it work now f yes, mark the thread as answered. -Jens. no - the log still shows the same errors - seems to be happening during one stored procedure which deletes and updates a table, but other procedures do similar work with no errors recorded - also happens when a scheduled maintenance plan backs up a database or runs reindex on a database - Log directory was not marked as shared - changed to shared directo ...Show All

• Tomas Petricek Invoice Detail

  Hi I have a invoice that displays the company name in a rectangle on top then it has a list in the list it has details tables my problem is that the invoice detail goes on the next page I need to have the company name as well on the second page I cant put it in the same table as the detail because I have a few tables in the detail so it is actually no header is it possible to have Repeated the Company name information on the next page Thanks A bit of a hack, but how about just creating another rectangle with visibility property =IIF(Globals!PageNumber.Value > 2) Not sure if that will work though since the body does not know about page numbers. Did you try Chris Hays's fix http: ...Show All

• Camac216336 Unhandled InvalidOperationException

  I have a database table called Qlinks, with two columns, URL and Name. This table is displayed on a form also called qlinks, in a details view. When I try to save data after i've deleted a row of the table, O get a yellow po-up telling me that the InvalidOperationException was unhandled. The error is " Update requires a valid DeleteCommand when passed DataRow collection with deleted rows." Please try to help, I am just a beginning programmer who doesn't know much. Code samples greatly appreciated. Thanks in advance. Ha, I didn't expect a reply after so long. I posted this last year. SQL 05 express doesn't seem to work very well on my computer. (I think it has something to do with the amount of memory I have.) I gave up on this one lo ...Show All

• dmadrian 64 Bit and 32 Bit Reporting Servers in same web farm

  Can I mix 64 Bit and 32 Bit Reporting Servers in same web farm I currently have a distributed environment with 2 32 Bit Web Servers and a 32 Bit Reporting Services Database server. I would like to add 64 Bit web servers to this configuration. Are there any issues with this This wasn't really a tested scenario, but I think in theory it should work. I mean I don't see anything in the RS product code that prevents you from doing so. It's always interesting when a theory is put to test though :). If you decide to go down this route, let us know any problems you find. ...Show All

• Keith Smith Delaying the Execution of a component

  Hi All, Is there a way wherein if I have three components in my package, A,B,C and I want the DFT C to be executed only after A and B is executed I have now connected A and B to C and made the two arrows from A to B to blue, but i guess that is not good enough. Will setting the DelayValidation property to true help here Because that the DFT C is totally dependent on A and B I should somehow ensure that there is a constraint set. Can someone guide me here Thanks in advance Mithun That is gr8.. Thx for such a quick reply.. Use the precendence constraints (arrow in the control flow) from A to C and from B to C ensure the task C is executed after both A ...Show All

• RayCan Using Configurations Class within Script Task

  How do I access the configurations collection of a package within a Script Task component Is there any sample code anywhere Thanks! You set SSIS configurations as part of the package definition, and the ability to set a variable value is a perfect use for them. Go to the Package menu, and select Configurations to set this up. I was hoping to read the config PathFile location information from it to set to a variable. THX. Not possible from what I can see. You are no longer allowed to access package objects as you may have done in DTS previously. I cannot see why the configurations would be of use anyway, they are essentially done with by the time any tasks ex ...Show All

• Fiddel I want to create link with 2 servers

  I want to create link with 2 servers is that possible to do that. for example is like this, ---------------------------------------------------------------------------------------------------------------- SELECT Products.ProductID, Products.ProductName, Products.CategoryID, Categories.CategoryName FROM [SERVER1].[Northwind].[dbo].[Products] INNER JOIN [SERVER2].[Northwind].[dbo].[Categories] ON [Products].[CategoryID] = [Categories].[CategoryID] -------------------------------------------------------------------------------------------------------------------------------------------- Products table has SERVER1 and Categories table has SERVER2 ...Show All

• FassaBortolo Imorting Excel 07 data into SQL Server 2005

  I have been trying to use the dtswizard.exe in SQL Server 2005 to import Excel 07 spreadsheets with no success. Any idea how this can be done As a work around I have been importing the Excel 07 data into Access 07 and saving the database as the older mdb extension, THEN importing the mdb file into SQL Server 2005. Seems silly though. To access native excel 2007 data, create an OLEDB connection manager (not an Excel connection) with the following connection string specific to the source file. Data Source=c:\data\myfilehere.xlsx;Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties="Excel 12.0;HDR=YES"; Access the spreadsheet in a dataflow using an OLEDB source with its select state ...Show All

• Saud Akhter How to choose the default hierarchy for a dimension?

  I created a server-time dimension and generated several hierarchies within the same dimension, does anyone know how to select a particular hierarchy as the default one I didn't see it on the properties for the dimension or hierarchy. Ah, that explains it. Sorry for my confusing terminology. Thanks, Chris + Mosha. Can you please explain what do you mean by " It seems as though the Reporting Year -> Reporting Quarter hierarchy is used by default " Chris - can you please explain what does "default hierarchy" means in AS Thanks ! The 'first' heirarchy is the default hierarchy. IE: The left most heirarchy in your model. C ...Show All

• z248910 FixedHeader JavaScript Bug?

  Hi I have a report with a table containing 26 columns, the tableheader is fixed when scrolling (nice) and I have set the leftmost column to FixedHeader. It is possible via paramters for the user to select which columns that should be visible. But when some columns not are visible then I get a script exception after rendering, 'children.0.style' is null or not an object, resulting in no fixed headers at all. If I remove som columns so that there is only 18... it works. Seems lika bug to me Where can I supply bug reports, I also have one upgrading bug concerning code page Regards Hi Fredrike Did you get any solution to fix the header of a rdl file which was showing the javascript error children.0.style is null or not an o ...Show All

• CDFAUX Poor performance processing data

  I have a problem with performance during cube processing (using ProcessData). When I start processing a number of partitions (in parallel), the network utilisation is initially 100%. Over the next 30 minutes the network utilisation drops to 10 % on the AS box. I have checked the database server and it is a similar story there. The processing eventually completes after a number of hours. Way over what our existing AS 2000 setup would take. In order to checkout my setup I wrote a .Net 1.1 utility which runs the partition queries in parallel and writes the data to file. It is able to max out the Network utilisation for the duration of the queries on both the AS and SQL boxes.(5 in parallel, totalling 250 million rows came accross in ...Show All

• Jon50 Replication: periodic initial snapshot not yet available

  I have a push subscriprion (publisher sql2000, distributor 2005, subscriber sql2005) that periodically (twice per month) changes it's status to " ... initial snapshot not yet available ...". Then I need to mark it as for reinitialization and start the snapshot agent (starting the snapshot agent without marking it for reinitilization doesn't starts the subscription to initilize itself). There is nothing important in the logs. Any suggestion why this may happen The network connections between distributor and subscribers sometimes are broken (it's over VPN), but there is a couple of other replication that goes the same way and they are fine... I have the exact same problem my transactional replication is pushing to 4 ...Show All

• YAIR_I Problem with UpdatePanel with Trigger, using MasterPage

  Hi all, I have a MasterPage with Calendar Control, and a content page with ListBox control. My plan is to have a post back on the ListBox, when the Calendar control "SelectionChanged" event fires. Both the Calendar control and the ListBox control are child elements of separate UpdatePanel controls. I have this code fragment in the content page "Load" event handler. if (!IsPostBack) { Microsoft.Web.UI. AsyncPostBackTrigger trigger = new Microsoft.Web.UI. AsyncPostBackTrigger (); trigger.ControlID = master.CalendarStartDate.ClientID.ToString(); trigger.EventName = "SelectionChanged" ; UpdatePanelItemMovers.Triggers.Add(trigger); } But when the page loads, I get this error: A control with ...Show All

• Joe Rattz Non-browsable custom properties

  Does anyone happen to know if it is possible to set a custom data flow component property to be non-browsable I have a number of custom component properties, and would prefer that they only be updateable through my custom UI as opposed to via the property grid on the SSIS designer, thanks This would apply to a task only. It doesn't work for a pipeline component, since properties are not defined as regular properties on a class, so unfortunately cannot be attributed as normal properties are. I cannot see a way to apply such attributes/settings to custom component properties. I would expect it to be on IDTSCustomProperty90 if anywhere. Browsable and read-only would be usefull properties to have there. ...Show All

• CyberEeyor Problem with reference dimension & snowflaked tables

  OK, this is a bit complicated, so I hope I can explain it clearly. I'll try not to get bogged down in the details of the problem domain, but bear with me. We have a cube with a regular dimension and a reference dimension. The reference dimension is connected through the fact table through the regular dimension (there are many other dimensions as well, but I'll simplify the situation here). Both the regular dimension and the reference dimension have hierarchies that that include as their top level a level called "System". For both of the dimensions, the "System" level is snowflaked in from the same table. So the regular dimension table contains a column called System_key, and a corresponding attribute. Similarly, the ref ...Show All