Answer Questions

• magicalclick Indirect Configuration with ConfigType 'Indirect SQL Server' fails

  Hi, I have a package that uses a Configuration of type SQL Server where the property values are held. This runs successfully using this direct configurations. When I use an Indirect configuration using an environment variable to point to this SQL Server configuration type the package won't even validate. The Indirect Configuration is: [EHC-SQLD-01.].[SSISConfigsDEV];[dbo].[SSIS Configurations DEV];pkgLRD CED Import; which follows the standard of : db connections, config table, filter This works by the way on my client but on the dev server the error is: Error: The connection "[EHC-SQLD-01].SSISConfigsDEV" is not found. This error is thrown by Connections collection when the specific connection element is not found. ...Show All

• Shilpa_nad Cannot shut down VS after using report designer

  Routinely when I use BIDS to work on a report design, I cannot close BIDS because I get a message box that says: Microsoft Visual Studio cannot shut down because a modal dialog is active. Close the active dialog and try again. Of course, there is no visible dialog open. I actually have to terminate the process from task manager. I do not get this problem when using SSIS or SSAS. Only SSRS. Any Ideas Thanks! BobP The problem normally occurs with me when I had used the query designer an has run an query. When continuing the work at some time sql server ask the question whether to keep the result set or not. When VS is not the active window this message is stuck behind the VS screen and you can not stop it. It i ...Show All

• Kent Boogaart Using AMO to manipulate cube calculations

  We have a cube with a bunch of calculated measures that were defined using BI Studio. I'm now looking at using AMO to manipulate the calculations (enumerate, modify, add, remove, etc). But what I see in the AMO object model is one MdxScript object with one Command object. That Command object has one very large Text property, with all of the calculated measure definitions munged together in one giant string. Not too easy to manipulate programmatically. Is there anything that I can do to make this easier to deal with Or is this just the nature of the beast with calculations, and I need to munge around in the giant script Is there some best practice (splitting things into multiple scripts, for example) that we missed I noticed that the AW dat ...Show All

• R.Tutus External Activation and Receive Timeout

  I have a set of service broker services setup that rely on external activation to process messages. I'm using the GotDotNet ExternalActivator, and it launches console applications that do the actual retrieval from the queues. The console applications are written to run continuously to avoid the cost of starting up .NET based console apps over and over again. I am observing very odd timing behavior. With the receive queues empty and the external activator configured to run a minimum and maximum of 5 instances, I observe in SQL Profiler that most of the receive operations finish in about the same amount of time as my WAITFOR command in my receive stored procedure. However, there is usually one receive command that consistently takes upwar ...Show All

• Jamie Thomson Red X show on replication monitor (publications is disconnected from replication monitor)

  I have setup transactional replication everything on one box. later(two or three weeks later), Replication monitor is show red X Under my publishers (publications is disconnected). this is SQL2005. Everyone known how to fix this problem Thanks, Frank In your distribution database, look in tables MSpublications and MSsubscriptions for entries that look like they should have been deleted, then manually delete them. This is assuming the red X is indicating a failure that you really don't have. ...Show All

• Robert M Accessing Variables in SSIS code

  Hi I am not able to access SSIS variables which are defined at Data Flow Task in a custom component. This custom component is developed by me in C#. How can i access these variables Please let me know if theres a way to access SSIS variables. Thanks, Vipul Hi Atul Thanks for the reply. After making use of VaribleDispenser i am able to get System variables. But when i am trying to access User variables, i m getting this error: Error: 0xC0047062 at Data Flow Task, i2ADI [91672]: Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: Failed to lock variable "User::sourceId" for read access with error 0xC0010001 "The variable cannot be found. This occurs when an attempt is ...Show All

• Spankmaster79 changing "header rows to skip" property in flat file connection during runtime

  Hi all I have a flat file.I am trying to set the value for the property " HeaderRowsToSkip " during runtime.I have set an expression for this in my "flat file connection manager". But this is not working.The connection manager is not able to take the value during runtime . My expression is as follows: DataRowsToSkip : @[user:: Var] where " Var " is my variable which gets the value from the rowcount component and trying to set it back to the "HeaderRowsToskip" property. I ve even tried setting the value to the " HeaderRowsToSkip " property in the expression builder. Its not working.... Can anyone help me out in solving this Thanks in advance Regards Suganya ...Show All

• yhal How to edit someone else's report definition?

  I need to be able to share report definitions with other people in my group, so we can all edit and makes changes to each report definition if the need arises. When I tried to use a shared folder the other person could not access my report def, so evidently there is security applied. What's the correct method to do this Please point me at the documentation if it's listed somewhere - even an MSPress book would be fine. This is for both SQLRS2000 and 2005. thanks Peter Yes, share the datasource as well. you will also want to make sure that the project properties are the same so the coworker can deploy new versions of the report. We are using VS2003 - we are using a ...Show All

• Hawkeye7 Modifying Triggers in Managment Studio Express

  I have a database with an update trigger, which shows up under the Triggers object in the database tree. When I modify the item and try to save it it prompts me for a disk location to save the query. I then reopen the item on the db tree, and it shows the old code. What am I doing wrong Mike Hi Cetin Its working -- thanks for that information. Mike Did you execute it ...Show All

• Stupidav page number & records number

  1. how to show page number & total page number in report body 2. how to show total records number Okay, I found the error. When I typed in the code for the post, I spelled "Function" incorrectly on the very first line... Just add the missing "c" and you will be good to go. Sorry about that. Joel I cannot get this to work. I get an end of statement expected error for the first line. I copied the code into report, report properties, code tab and change the function names to suit my naming convention. Also, when I try to refer to the functions in a textbox Code. FunctionName does not recognize the function in the custom code section. ...Show All

• KeshavT CREATE ASSEMBLY ERROR -- an implicit reference of some kind ???

  When I run this ... CREATE ASSEMBLY asmRANDRTCalendaringGateway FROM 'E:\sql\RANDRTCalendaringGateway.dll' WITH PERMISSION_SET = UNSAFE I get this error ... Msg 10301, Level 16, State 1, Line 1 Assembly 'RANDRTCalendaringGateway' references assembly 'system.web, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(The system cannot find the file specified.)). Please load the referenced assembly into the current database and retry your request. Even though I do not explicity refer to system.w ...Show All

• hlj16 Where to build client application for SQL 2005 standard edition

  Hi, I have a database working on SQL Server 2005 Standart Edition and i want to create a client windows form aplication. My problem is where to do it Im trying to use MS visual basic 2005 express edition but it doent support SQL Server 2005 Standart Edition, it only supports SQL 2005 express edition. What should i do And in the visual studio 2005 that comes with the package of SQL Server 2005 standart edition there is no project of a winodws form. Please help Thank u for answer I was just hoping...;) Could you please mark an answer if you are satisfied. thanks, D great, so please tell me where should i post it so that u can answer i can help you but this ...Show All

• Vic02 Reporting services with SQL Express

  Ok, here's the deal. I'm just learning sql express and I'm trying to get my reporting services worked out. I have everything installed and I have managed to connect to the report server at http://<computername>/Reports my problem is I can only connect to this page when I am at the machine where the sql database, reporting database, etc... I cannot log on to this site from any other computer no my network Does any one know why Thanks!!! Hi, do you get an error message -Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- I suggest you ask this question in the Reporting Services forum. Mike I get a page cannot be displayed in the browser window when I try from a different mac ...Show All

• SSAS_STUDENT RS2k5: Sum(field,scope??) problem

  Hello, I have problem with aggregation methods in RS 2005. I have a query thar returns data set: Department, Storage, Article, Invoice, Quantity, Value, ValueX 3, 1,'Art A' ,'Inv 1',2,30, 5 3, 1,'Art B' ,'Inv 1',4,40, 7 3, 1,'Art A' ,'Inv 2',1,15, 5 3, 1, 'Art B' ,'Inv 2',2,20, 7 3, 2,'Art A' ,'Inv 3',1,18, 3 3, 2,'Art B' ,'Inv 3',2,16, 4 ValueX - this is value returned by UDF. It is unique for every "Article & Storage group". In RS my report looks like this: (grpDepartment) Department, Sum(Quantity), Sum(Value), Sum(ValueX, scope ) (grpStorage) +Storage, Sum(Quantity), Sum(Value), Sum(ValueX, scope ) (grpArticle) ++Article, Sum(Quantity), Sum(Value), ValueX ...Show All

• RobertMC Sql query for Master Detail Record in One Row

  I am having a table contains Nurse Detail like nurseid 1 address fname last name phone another table contains the exp detail in 28 different type of speciality nurseid specialiity year Exp. 1 icu 4 1 ccu 5 1 OPD 2 i need to display the record in datagrid as nurse Name ExamPassed Address MostExp SecondMostExp 1 toefl abc, india ccu icu if i use the select query to find the top two inside a datareader which collect the info. about each nurse this takes lot of time to complete this and many times gives Timeout error about(50%) is there any code to combine with the urse detail records as a column for speciality one and two. any stored procedure / se ...Show All