Answer Questions

• mahima Remark some task or data transformation component

  How could I remark my script component, It is isolated, I just wanna check something without losing the long script written inside. Thanks, Fahad Fahad349 wrote: This was my assumption. I am looking for a better way Well, that's pretty easy, but you can try this... Right before the script component that you want to remove, add a multicast transformation. Connect one output of the multicast to the component right after the script component. Then hook another output of the multicast to the script component. Hook the output of the script component into a row count transformation. Of course, you have to disconnect the script component from the next down-stream component first. Can you be more specific as to what you a ...Show All

• jitter123456 c# UI Escape character problem to execute command line

  Hi! Thanks For your reply! but this is very urgent please help!!!!!!! I need one more help in this issue. what if i do not need any \ " for e.g: i am trying to set conn string and varaible value jobCommand = new SqlCommand("xp_cmdshell 'dtexec /f \"" + path + "\" /Conn \"" + Packconn + "\" \"" + connect + "\" '",cconn); i am getting some value like this : CommandText "xp_cmdshell 'dtexec /f \"D:\\SSISProject\\Integration Services Project1\\ArchiveMainMultiTables.dtsx\" /Conn \" SE413695\\AASQL2005.TestDB; \" \ "Provider=SQLNCLI.1;Data Source=SE413695\\AASQL2005;Initial Catalog=TestDB;Provider=SQLNCLI.1;Int ...Show All

• dakota367 Remove SP1 or install SP2 Dec. CTP

  This sounds trivial but it has become an issue here. We had the original RTM of SQL2005 with Reporting Services installed and running fine. We were explicity NOT installing SP1 because of a feature that was removed from reporting services (the select-all checkbox in the multi-value parameter). This feature is supposed to be back in SP2. So wouldn't you know it, somehow someone inadvertently installed SP1 in the course of doing windows updates and now users are complaining about the missing select-all checkbox. I figure my options are to either install the SP2 Dec CTP or try uninstalling SP1 (if that's even possible). Any recommendations Ah! there is a hotfix addressing this very issue. I will try it. ...Show All

• Nicw Connectivity issue

  I am using the connection string as "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=TMS_CHECK_CONVERSION;Data Source=PHILDCAP4Q\VENDOR" in specified named instance is installed on the Respective machine. It is giving the following error., Sqlserver does not exist or access denied., Please suggest ... Yes I am using windows authentication only also sql server is a member server in the domain. still I am getting the same error. Any help is appericated. The most astonish thing here is., we are able to connect through delphi code and we are doing database operations. But when we are trying to connect ...Show All

• pavc Increase Tooltip display time?

  Hi All, Is it possible to increase the amount of time a tooltip is displayed within report manager Regards, Jon Hello can u tell me How to put tool tip in My report. thanx ki No I don’t think that this is customizable within the report. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- Hi Ki, In the properties box all objects, in the "General" tab is an option for "Tooltip". You can put an expression in here to define a tooltip. Regards, Jon There is a setting for controls naming tooltip which can define any tooltip displayed if you hover over the speci ...Show All

• Vyatsek distrib.exe --- Many instances running

  How many instances of distrib.exe should be running Yesterday I created multiple publications in SQL 2005. without counting, it looks like each publication has its own distrib.exe.... it this the way it is supposed to work Each instance it holding 8k of ram (not a problem right now) but I have many more publications to create... Please let me know if this is the way SQL server works now Thanks for the explanation. I just wanted to make sure it was normal... The reason for the multiple publications is not for the purpose of the subscriptions but rather the publications them selves. We have about 200 table that are changing several times a year based (data lenghts or additional columns). Th ...Show All

• x.P.e.r.t F.M. Degenerate Dimension with Partitions

  Backgroud: My cube has 12 Partitions, and I set 12 fact tables to point to them. There is a Degenerate Dimension, which I point to fact table 11. By the Way, the Degenerate Dimension's Key is The fact Table 11's Table_ID, and the Table_ID is possible to be the same between diffrent fact tables 1 to 12. Question 1: when I build the Degenerate Dimension, I can only choose one fact table to match, as you know. then if I ProcessFull the Degenerate Dimension, it will catch the data from other 11 fact tables If the answer is YES, how about the same Table_ID Question 2: If I processFull the Question Degenerate Dimension, need I Process the Partitions 1 to 12, or only to Process the Partition 11, or not need to Process Partitions Question ...Show All

• ChaosBlade SSIS Designer freezing up when using the Debug utility !

  I am executing a single package that references 180 other packages , after executing the first 90-100 packages , SSIS designer completely freezes and then i have to kill the session using Task Manager . Is this a limitation of SSIS or is it a system constraint If you have any suggestions or workarounds for de same plz do reply Thanks in Advance Shailesh Shailesh Chaudhary wrote: I am executing a single package that references 180 other packages , after executing the first 90-100 packages , SSIS designer completely freezes and then i have to kill the session using Task Manager . Is this a limitation of SSIS or is it a system constraint If you have any suggestions or workarounds for de same plz do reply Thanks in Advance Sh ...Show All

• No-spam Sam How to load data from a data warehouse to a Cube ?

  Hi All, I am just curious to know how I can load data from a data warehouse to an Analysis Service Cube (both to the fact tables and dimensions). Whenever there is a change in the data warehouse, it should be reflected to the fact table and dimension Does any body have some way to achieve this I appreciate if any body provide me a good material which describe this scenario. Sincerely, --Amde I understand what you are saying. I want to confirm one thing. Let's say we have 6 dimension, we need to create 6 jobs and schedule them at the same time. Am I right saying that --Amde If you open Analysis Services 2005 in management studio and expand the database ...Show All

• Wayne.C Stored Procedures - SourceSafe

  Hi All... Well, another old c++ programmer has found the Lord - I've just written my first stored procedure. And yes, as I've always heard, it's quite cool... The thing I've never really cared for though is that they sit way out there in the database, far away from all the "other" code. I'm presently involved in an asp.net project and we use SourceSafe. I've seen some mention of VSS with SQL Server on this site and am quite pleased to see it! But for the sake of an old c++ programmer, what are the basics about getting things like stored procedures (and even the database schema for that matter) into sourcesafe That is what's the easiest way to do it ; ) For what it's worth, we're using .Net 2.0, Visual Studio 2005, SQL 200 ...Show All

• indersunny Frequently update and select Table Locking Problem

  Hi guys,               I faced problem related to Locking and Isolation Level on Table(s).               My problems is there r some tables which r frequently updated, and I also want to fire select query over   those tables every 1 seconds and want to get only committed records.             In current scenario we start transactions with ReadCommitted Lock for updating records. But in this scenario I can’t get select query result because of some of recourses r used by transactions so after some time it gives Deadlock error .     ...Show All

• zille Distribute Report based on content

  I am just getting started using subscriptions in SQL Reporting Services. I am using version 2000, on Enterprise Edition. Here is my situation. Can someone please let me know if this is do-able and perhaps point me in the right direction. I have a table with a series of 'jobs' or 'projects' in it. Each row has an employees name and email address in it. I currently have a report set up that reports information on all of the 'jobs' for each employee. It uses a simple selection list as a parameter. I would like to modify this so the report is automatically emailed to the employee on a scheduled basis. Employee A would receive a report that has all of the information for Jobs he is managing. I would also like this to be dynamic so if n ...Show All

• Dragan Jankovic Good design?

  Hi! I want to add "inheritance" to my database. I have of table X witch attributes a1, a2, a3, a4, a5, a6 and second table Y with attributes a1, a2, a3, a7. I want to create additional table Z with attributes 1a, a2, a3, key and tables X: key, a4, a5, a6 and table Y: key, a7. I have more of those sub-class. Set of common attributes is about 5-10. Additional attributes range from 1 to 20 per table. We have also large dynamics of our database. Often (1 per month) we have to add about 2-5 attributes to some subclass (or remove some attributes). It's good idea for "attributes inheritance" I know those disadvantages: to insert (update, delete) record from X, I have to insert record to Z and X I fou ...Show All

• stswordman Programmatically get ScriptTask source code

  Hi am trying without luck to load a package which contains a ScriptTask and read the source code of that task. I can load the package and get the ScriptTask no problem. However i am not sure how to get the source code. I know i have to use the ScriptTaskCodeProvider and i assume the GetSourceCode () method. This is what i have so far ScriptTask scriptTask = taskHost.InnerObject as ScriptTask; ScriptTaskCodeProvider codeProvider = new ScriptTaskCodeProvider(); codeProvider.LoadFromTask(scriptTask); string sourceCode = codeProvider.GetSourceCode(scriptTask.VsaProjectName); Any assistance greatly appreciated. Cheers Richard. Application application = new Application (); Package package = application.LoadPackage( @"C: ...Show All

• Syed Mahmood Ali How to combine Multiple Dataset result in each row of the report

  Hi, I need to produce a report in MS SQL Server Reporting Service 2005 which has some date fields & need to pass these date fields to find out the no_of_User on that date from another database. For example Itemid Availabilty_Start_Dt Availabilty_End_Dt User_On_St_DT (this info is in another DB & need to pass Availabilty_Start_Dt ) User_On_ED_DT (this info is in another DB & need to pass Availabilty_Start_Dt ) I am facing two problem here. Since hereis two different dataset needed how can I combine the dataset result to produce each row of the report. REally appreciate if anyone can show me some light on it. Regards, write a strored procedure in the backend and t ...Show All