Answer Questions

• Bartley Is this SSAS bug fixed in SP2 ?

  Can someone with the SP2 beta installed try the following and tell us if the formatting bug has been fixed (using the provided Adventure Works DB) with member [Measures].[DP] as [Measures].[Reseller Order Quantity] / 1000000000 select [Measures].[DP] on 0, [Reseller].[Business Type]. members on 1 from [Adventure Works] On SSAS 2005 SP1, I get scientific notation for the 2nd and 3rd rows returned by the query (as in 2.2076 E-05 ) This is a major issue for us as we tend to run SSAS queries from SQL Server using OPENQUERY. For instance, the following query fails because of this bug: select convert ( money , isnull ( substring ( "[Measures].[DP]" , 1 , 50 ), 0 )) from openquery ...Show All

• arcliner 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

• A kid toggle all

  I have seen other places where this question is asked, but I am still not seeing the answer clearly. If I have many groups that are collapsed and I want to expand them all at the same time, it there a way to accomplish this Many talk about a param that can be passed in, but even if you have the parameter set, this is only for the initail state, is it not You can change the initial toggle image state by right-clicking on the textbox, opening the textbox properties dialog and selecting the "Visibility" tab. The bottom of that dialog tab has a section titled "Initial appearance for the toggle image of this report item". You can set the initial toggle image either statically or based on a ...Show All

• Ian Barber SSIS Package will not execute when DontSaveSensitive protection level is selected

  Hi, Can anyone explain to me why my ssis packages will not work when DontSaveSensitive protection level is selected My package configurations are set as SQL server configuration type, and I have a table in a database that contains all the sensitive information (passwords and such). If I select "EncryptSensitiveWithUserKey" everything works, but I will be the only one able to execute the packages (not good, I need others to be able to execute them as well). The error I'm getting tells me that the connection is not configured correctly or I may not have the right permissions on the connection. My guess is that the DontSaveSensitive drops the passwords, but when I edit the data source and re-enter the password, it still do ...Show All

• zzpinkie Server options are not being executed from local programatically code??

  Dear all, For example, executing a DTSX stored in a server, execution is fine and successfully but the log file attached to that DTSX is not created at all after the execution. Otherwise if I'm going to execute from the server everything is fine: log file is created and gathering the usual information. Let me know if exists any option for to enable this from the own DTSX. If I run local packages log files are created without problems. Thanks in advance, And the log file Where is it -Jamie yes, the log file is stored on the server no in my local hd No. What is the path to the file I'm trying to determine if its a UNC: \\MyServer\Myfilelocation\Myfile.log or a local path: c:\Myfil ...Show All

• DavidR100 sql data types vs is data types

  Hi, I want to store a decimal value which I get from an execute sql task into a package variable. Which data type should I specify when creating the package variable Thanks, Tom   Tom De Cort wrote: Hi, I want to store a decimal value which I get from an execute sql task into a package variable. Which data type should I specify when creating the package variable Thanks, Tom   Here is the solution: I store the original decimal value in a package variable of type object. When I want to store it again in my database via an execute sql task I select as variable type option (in parameter mapping tab) a double. In that case SSIS does the casting automatically fr ...Show All

• Alex Belik Oracle 7 query

  Within a VS 2003 BI project, I can create a parmeterized query against an Oracle 7 database by using a for the parameter(s). Example: SELECT LTrim(RTrim(SWO_ISS.REF)) ACCT, CUS_LOC.NAME CUSTOMER, SWO_ISS.TRAN_DATE, SWO_ISS.ITEM, ITM_DESC.ITEM_DESCRIPTION, SWO_ISS.QTY, LSTPRC.AMT FROM MYDB.SWO_ISS, MYDB.CUS_LOC, MYDB.ITM_DESC, (SELECT LP.ITEM, LP.REVISION, LP.AMT FROM MYDB.LIST_PRC LP WHERE LP.EFFEND > SYSDATE) LSTPRC WHERE SWO_ISS.REF = CUS_LOC.CUS_LOC(+) AND SWO_ISS.COMP_ITEM = ITM_DESC.ITEM(+) AND SWO_ISS.COMP_ITEM = LSTPRC.ITEM(+) AND SWO_ISS.COMP_REV = LSTPRC.REVISION(+) AND SWO_ISS.REF = AND SWO_ISS.TRAN_DATE >= TO_DATE( ,'MM/DD/YYYY') AND SWO_ISS.TRAN_DATE <= TO_DATE( ,'MM/DD/YYYY') Unfortunately, as soon as the dataset is ...Show All

• Toby Broom Any other way but Cursors or While loop

  Hi all, I have a bit of a challenging on my hands with this, i have a result set in a table which i am trying to iterate through the rows one by one i.e Values Values Dates 1.10 1.20 1.30 1.40 2006-03-31 00:00:00.000 2006-06-30 00:00:00.000 2006-09-30 00:00:00.000 2006-12-31 00:00:00.000 go to each row get the value and the date perform some calculation with the value and the date and insert it into another table(which sounds easy enough) my problem is how do i iterate through the result set one by one without using a cursor or a while loop do i have any other options at all Hi Thanks, For your reply below i ...Show All

• TBotnik Drillthrough Query

  I have the following Drillthroug query. i require it to return only those documents that fall within a given date range for a particular customer and worktype. But all the records for a customer and worktype are returned irrespective of the date DRILLTHROUGH maxrows 10000 SELECT [Measures].[TAT] ON 0 , ([Hierarchy].[CustomerName].[ABC], [Hierarchy].[Work Type Name].[EEG] ) on 1 FROM ( SELECT ([Date].[Short Date].[2004-03-15] : [Date].[Short Date].[2006-04-10]) ON COLUMNS FROM [DW]) Return [$Customer].[CustomerName] As [CustomerName],[$Measures].[TAT] AS [TAT],[$Document].[Document ID] AS [Document ID] Hello Reena, First of all bad news: AS 2005 doesn't allow DrillThrough to be performe ...Show All

• rivers Using SQL Express from Visual Studio Standard

  Greetings,   I have a version of C# Express Edition on my computer and it works just fine with SQL Express.  I also have a full version of Visual Studio Standard 2005, but unfortunately it won't recognize SQL Server.  At first when I tried adding a database to a project it popped up a small dialog that  said, "Unexpected Error".  I looked in the options to see if there was something that I need to do to get Visual Studio to recognize SQL Server Express.  It had the name SQLExpress in the textbox "SQL Server Instance name (blank for default)", so I cleared the text box to see if Visual Studio would reconnect to SQL Server properly and then I went back and added a new database to my project again.  Th ...Show All

• deen Union all does not union all rows

  Hi all, I have a Union All transformation with 4 inputs and one output when I debug the package the sum of the different inputs rows does not match the row count in output. I don't understand, I've used the Union All transform many times and I've never seen this. Any idea why this could happen Are you talking about the arrow on the SCREEN or the output table saying 350 records Is it REALLY outputing 500 rows, or 350 in the next step It might just be a screen display issue. For example it is displaying the first record set to reach the union or the last or something. I tried what you described and am unable to duplicate a problem with the union all (on SP1). ...Show All

• longint using copy database wizard

  we need to move databases from one SQL Server 2005 to another SQL Server 2005 server. We are using the copy database wizard. We are planning to move the databases using the SQL management object method rather than the detach and reattach method. Both ways transport logins without an issue. I also know that the SQL management object method is slower. Other than speed is there any reason I should use the detach and reattach method over the SQL management object method or is there a better way. JJDS wrote: I tryed to use the Copy Database Wizard on the SQLMStudio and with dettach an re-attach no problems. With the DB with everything equals less the atach re_attach, in use ...Show All

• OffbeatPatriot data mining 2000

  i want show other products when somebody choose a product, ect: product1 product2 A B, C ,D B C,D,E C F, G ....... i create model: I create a mining model: CREATE MINING MODEL [bh'S] ([Cusid] LONG KEY , [Products] TABLE PREDICT ([Productid] LONG KEY )) USING Microsoft_Decision_Trees INSERT INTO [bh'S] (SKIP, [Products] (SKIP, [Productid])) SHAPE {OPENROWSET(…, 'SELECT DISTINCT "dbo"."customers"."cusid" AS "Cusid" FROM "dbo"."customers" ORDER BY "dbo"."customers"."cusid"')} APPEND ( {OPENROWSET(…, 'SELECT DISTINCT "dbo"."orderdata" ...Show All

• Raphael Pina making Report Parameters optional

  I’m currently working on a report (SSRS 2005) with parameters which I want to make optional. In other words: when I open the report in the preview or IE, I’m always forced to enter values for every single parameter. But I want to have them optional so I can decide whether to choose values (as the option "Multi-value" is enabled) or leave them blank. (ignore in selection result) is this possible - I hope;-) thanks in advance pamike The way to make entering parameter values optional is to give them default values. You can set the default value to give you all results and thereby achieve your result. hi thanks for the answer csi_hugh, but i still don’t k ...Show All

• Manolis Exception 0xC0010009 occurs when Source AccessMode defined as 2 and Destination AccessMode defined as 3.

  I am trying to create a SSIS package with following logic SourceComponent property AccessMode is defined as 2 and Proper SQL string is provided. Now, if I defined Destination Component Property AccessMode as 2 and provide the same SQL string (it is connecting to different DB) Everything works fine. But When I defined AcessMode as 3 and provide other properties which are applicable for accessmode 3, it throws Exception 0xC0010009 on IDTSExternalMetadataColumn90 externalMetadataColumn = externalMetadataColumns[ouputColumn.Name]; Here is the code I am using it. The exception is thrown on LINE when I Changed these lines . Please HELP! oledbSourceMetadata.ComponentClassID = "DTSAdapter.OLEDBSource" ; oledbSou ...Show All