Answer Questions

• AlGee Display Selected Parameters in Report

  Is there a way of showing which parameter values were chosen from a multi-value parameter list in RS 2005 I want to show in the Report Header the parameters that have been chosen. There are "Count", "Value", "Label", "IsMultiValue" options in the expression builder for the parameter but no way of knowing which ones were selected Found the answer....from Robert.... ...Show All

• Camerons SSIS Extension Catalog

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All

• boorad Datafields in report header

  Hi. I want some information stored in the database to be shown on the top of each page in my report. But in the report designer I get an error message if I try to drop a table in the header, and if I try to assign the value of a textbox in the header to e.g. "First(Fields!sometable.Value)", I get a runtime-error in the preview that says "... Fields cannot be used in page headers or footers". How can I do this Regards, Tomsi ...Show All

• vwgolfman sql problem in stored procedure

  hello everybody, I am writing a stored procedure to update some table in different database. The database name will change and table name will not change. Thus I pass a parameter into store procedure. However, sql in stored procedure cannot run the following query. I want to check the cursor record whether exist or not. Could you help me to solve the problem. if exists(Select * from @strshop where sku = @skutemp) ------------------ --it cannot r ...Show All

• SLIDER 82 decimals

  I need to learn to format text boxes in the report design to not have any decimals but to have commas when needed. Any help is appreciated. You can just set the Format property of the textbox using Standard Format Strings. For example c2 is Currency with 2 decimals. I think what you want is n. Check out the link so you can decide for yourself the format you are looking for. If the Standard formats don ...Show All

• Donald D. Drake CLR and SQL 2005 Compact Edition

  I believe that there is a also a new SQL database for the PDA. Am I right Is it also possible to use (CF) .Net code inside this edition Yes. It's called SQL Server 2005 Mobile Edition. This works on Windows Mobile devices (PocketPC and SmartPhone). You need to install .NETCF 2.0 (compact framework) on the device for using SQL Mobile. You can develop mobile applications using Visual Studio for Devices. SQL Mobi ...Show All

• ChopKiwi How to remove ALL as a dimension member

  Is there a way to remove the ALL member that Analysis Services adds to each dimension thanks. Setting the IsAggregatable propery to True does remove the 'ALL' dimension member but now my application only receives the first member from the Dimensions Level. Is there another property that I should change in relation to this I've messed around with some of them to no avail. BTW I'm using AS 2005 and access ...Show All

• whoareyou Package Validation Error + Code 0xC004801C

  Hi, I am learning to use SSIS for creating packages. I am getting the following error when I try to execute my package... Package Validation Error Error at Data Flow Task[DTS. Pipeline]:The "runtime connection "FlatFileConnection "(122)" in the connection manager collection, Connections, of component "Flat File Destination ("120") does not have a value for the ID property. Verify that the Connect ...Show All

• Neil D dynamic query

  hi, i'm using dynamic query in the dataset because i wanted the result to group by the particular parameter selected. however, another parameter requires the data to be taken from another table. is the following syntax acceptable =if (Parameters!rev_data = 'A') begin "select a,b,c.... from tableA" end else begin "select d,e,f.... from tableB" end i encounter this error : 'Expression expected'... is the ...Show All

• Nate Cook Stored Procedures in SQL 2005 Express

  Is it possible to create and use stored procedures in SQL 2005 Express As noted by someone else in an earlier post, you can right-click the stored procedures folder, get a template, code a stored procedure, and save it to a project file. However, whereas the earlier thread suggested that one could save the sp to the database by clicking !Execute, this does not work for me and I can find no other obvious way to make the sp accessible to my code-b ...Show All

• TanvirA Indirectly config the Package but it didn't affected

  Dear all, I have built an SSIS package by using the BI Dev Studio and enabled its configuration xml file. The package have a variable called TranDate and I want to put it dynamically from a Calendar on my website (just like assigning a variable). I have successfully change the value of that variable in the configuration files (affected to the xml file). Then I loaded the package and executed it (through my web). It's still get the ol ...Show All

• ChrisNickel Scaling Model for Sales Force Automation

  Read only transacted replication to about 60 clients. 100 or so transactions a day (8 hours), transaction (record) is probably about 8K/transaction. Reliable connection over 100base-T. Latency - 15 minutes would be great. This doable -- I couldn't find a timing/ sizing model any place. In a nutshell, it's doable. Aside from the usual hardware limitations (memory ,CPU, disk, etc., which you should be OK if you have multi-proc, ...Show All

• Eldad Hertz SQL Task - Output Parameter fails using strings.

  Scenario: Using Execute SQL Task in SSIS. Connection Type: Ado.Net IsQueryStoredProcedure: True SqlStatement: [spAdoNetParamTest] I trying to return a output string from a stored procedure and place the value in a package level variable.  I am able to do this with other data types.  See sample SP below.  However, the task fails when trying to return a string with an error.  Does anyone know how to set the size property for a ...Show All

• acido Executing .sql file using in .NET

  Hello, I want to execute .sql files against my database in c#. please Help me. Or you can split the file .sql file into multiple files at the lines where the "GO" commands were originally. Do you want to execute more than one file in a directory Or what do you want to achieve HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- I assume this is the problem you are r ...Show All

• anelson45 Blank Row comming out from Excel Source?

  Hi, I use an excel datasource to populate some simple dimensions, but when i extract the excel file i get alot of blank rows from the excel files... How can i overcome this issue Is this normal I never had problems like this using DTS in the 2000 version Best Regards, Luis Simoes Perhaps, your Excel file has empty rows in the spreadsheet. You should not see any difference when using DTS or SSIS wizard if the same source ...Show All