Answer Questions

• billqu Howto use COM objects in CLR. NET programs

  hi, i have a vb.net progi which i want to run under sql server 2005 as CLR. the prob is that when i want to create the assembly in sql 2005 it says that the create of the Interop.FC_COM.dll (this is the COM interop object) failed. when i try to create the Interop.FC_COM.dll as an assembly in sql 2005 it fails because this dll is not follwing the structure of a CLR dll. i've heard somewhere that MS is not supporting COM objects under CLR directly. is that true any comments welcome, thnx Permission set SAFE EXTERNAL_ACCESS UNSAFE Code Access Security Execute only Execute + access to external resources Unrestricted Programming model restri ...Show All

• ramraja_55 update with sum

  i want to sum up the values during the update process but error raises You need a SELECT befor the SUM(...). UPDATE T1 SET ParentBandStd = (SELECT SUM ( T3 . NettStd ) FROM STAGING . DBO . CUSTOMERBANDINGLOAD T1 INNER JOIN PRESENTATIONEUROPE . DBO . CUSTOMER T2 ON T1 . LOCALPARENT = T2 . LOCALPARENT INNER JOIN PRESENTATIONEUROPE . DBO . SALESANDORDERS T3 ON T2 . CUSTOMER = T3 . SHIPCUSTOMER WHERE T3 . INVOICEDATE >= @STARTDATE AND T3 . INVOICEDATE <= @CURRENTDATE AND T3 . TRANSTYPE = 'L') ...Show All

• ghostnguyen Looking for a comparison of Reporting Services 2005 and BO Crystal Reports XI

  Does any one have a feature list for Reporting Services 2005 and a comparison with Business Object Crystal Reports XI Can you share it There is a conversion white paper at http://www.microsoft.com/sql/techinfo/whitepapers/migrate-crystal-to-reporting-services.mspx . There are some other comparisons on the net as well. ...Show All

• Stanislav Ogryzkov How to Fax Reports from SSRS 2005

  How do I fax out reports from SQL Server Reporting Services (SSRS) 2005 I tried RightFax 6.0 but it didn't work. Do we have to be on a certain version of .Net (like 2.0 Framework) to use the printer custom extension Yes, you need .Net 2.0. See http://msdn2.microsoft.com/en-us/library/ms160778.aspx . You will need to create a custom delivery extension. The best way would be to start with the Printer Delivery extension that comes with the SQL Server Samples. Bret Updegraff Microsoft MVP,MCAD,MCSD,MCDBA Author - Reporting Services In Action 2nd Edition http://www.manning.com/updegraff Does the Printer Delivery extension allow you ...Show All

• matt01 Adventure works database, I can't connect to the database

  Database not found ! My web.config file has this bit of code: < connectionStrings > < add name = " AppConnectionString1 " connectionString = " Data Source= &quot; .\SQLEXPRESS &quot; ;AttachDbFilename= &quot; C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf &quot; ;Integrated Security=True " providerName = " System.Data.SqlClient " /> </ connectionStrings > But........................... the is no "AdventureWorks_Data.mdf" in that folder And the database is installed in the right place ! help ! When you downloaded and installed the AdventureWorks sample, you were proba ...Show All

• ngy_tms Raw File reader utility?

  Does anyone happen to know if there is a raw file reader utility available One of my processes drops a couple of interim raw files and I'd like to be able to look at the data in them in a columnar format without having to run a downstream data flow with a reader inserted. Simon, Whats the best place to provide feedback If you need to do this, then temporarily redirect to a flat file, look at your data, and then put back the raw file destination. Or, temporarily throw a multicast in right before the raw file destination and add a flat file destination. That'd be your best option. Just awesome, man. I don't have a lot of cash, but I'm kicking a few quid you ...Show All

• mitasid How to solve Circular Reference in Analysis Service

  Is there any way to solve a circular reference in Analysis Service calculation I'm migrating a Excel model to Analysis Service cube, but in Excel I can iterate to solve circular reference, but in Analysis Service calculations I can find a way to do that. This thread has an example of an iterative calculation implemented in AS 2000: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=203198&SiteID=1 Re: Iterative Calculations Analysis Server 2000 Edit Post | Delete Post(s) | Split Posts | Lock Post Hi Garron, Since your sample only involves iteration, without using data from any specific OLAP cube, the MDX below uses the Foodmart ...Show All

• MattyBoy4444 Aggregate Count Zero or NULL - multiple measuregroups vs. single measuregroup

  Hi Quess this fact table (100.000 Records a Day) Dim1 | M1 | M2 ---------------- A | 1 |NULL B |NULL| 2 C |NULL|NULL D | 3 | 4 I create a cube on top with four measures - for each a LastNonEmtpy and a count measure the result is Dim1 | M1*| M2* *)=Count measure ---------------- A | 1 | 0 B | 0 | 2 C | 0 | 0 D | 3 | 4 Is there a way to get a null value instead of a zero value in SSAS2005 (Build 2153) I have already thought about create a measuregorup for each meausre with a view related which filters the null value rows - but I guess the cubesize will increate much if I have a measuregroup per fact measure, because the dimension information needs storage too - I guess I need the count measure for calculati ...Show All

• Smalldust Mining structure has to contain at least 2 mining models to see their accuracy charts?

  Hi ,all here, Thank you very much for your kind attention. I just found that I am not able to view the accuracy chart for my mining model. The error message is: no mining models are selected for comparision. Which is quite strange. Any guidance thank you very much. With best regards, Yours sincerely, Hi, Jamie, Yes, my mining model is clustering model. So as you mentioned, seeing the accuracy chart of clustering model is restricted in there If so, what's the resolution Thank you very much for your further guidance. With best regards, Yours sincerely, The accuracy chart is only useful if your model has a predictable attribute (column), and the accuracy of the prediction can be evaluated against som ...Show All

• smalamas Attempting to obtain report name or identiy using CheckAccess method in SQL Reporting Services 2005

  I found some dead-end threads regarding this issue but have not seen a clean solution. Utilizing a Reporting Services security extension, I can't find a way of obtaining the reports name or identity from within the CheckAccess() method so I can use it to query an external database to ascertain authorization. In other words, my company requires the creation of custom roles that can be used from within our ASP application and well as being honored by SQL Reporting Services 2005. If anyone can help, I would really appreciate your time! Thanks in advance, Tom Great! Thanks! The identity should passed under the use ...Show All

• Tufelix Generate and save a report from reporting service ( remote processing)

  If I have an asp page with a button, what are the means or methods to trigger the event to process a report, save into a report and store in a file server or any directory All these is done backend without the need to display to the browser. Using RS Web services or Delivery extension programming things like that Regards Alu Hi Alu, I can't help directly with programming ASP buttons but . Have you considered using reporting subscription service, go to report manager , view a report , subscription tag. You will then have the choice of process a report, specify the report file type you want , saved in a directory you specify on a schedule you want . If you have specified reporting services e-mail setting you will ...Show All

• amendez Save TextBox to Database as new row?

  (VB 2005 Express) I have a textbox linked to a DataTable (database). I want to save its text into the database as a new row. What is the VB code The following is not working. Me.Validate() Me. my DataTableBindingSource.EndEdit() Me. my DataTableTableAdapter.Update(Me.myDatabaseDataSet. my DataTable) Thanks for any help. There's a great learning resource here. Over 16 hours of video for free from Microsoft: http://msdn.microsoft.com/vstudio/express/vb/learning/ ...Show All

• Manuel5 SQL Server 2005 Mgmt Studio: save table vew positions

  I'm in stage of manually populating a database that requires me to have about a dozen tables open simultaneously. It would be great to be able to save the tables, locations and sizing so that these can be recalled and opened automatically. Currently I do a screen capture, which is pretty lame. Any suggestions would be welcome. Rob - Thanks for the quick reply and offer of assistance, but scripting the population of these tables (for an ecological simulation model) is not feasible, since it involves a relatively small number of entries in the top level tables (dozens only) with a lot of dependencies among subtables. This is lieterally done by reading the content from PDF documents (and others) and entering by hand! We do empl ...Show All

• AlucardHellSing ETL Delta Pulling Huge data.. Right approach ?

  Hi all, In an approach of building an ETL tool, we are into a situation wherein, a table has to be loaded on an incremental basis. The first run all the records apporx 100 lacs has to be loaded. From the next run, only the records that got updated since the last run of the package or newly added are to be pulled from the source Database. One idea we had was to have two OLE DB Source components, in one get those records that got updated or was added newly, since we have upddate cols in the DB getting them is fairly simple, in the next OLEDB source load all the records form the Destination, pass it onto a Merge Join then have a Conditional Split down the piple line, and handle the updates cum insert. Now the question is, how slow the s ...Show All

• Dot Dot Dog Problems with neural net viewer, lift chart and predictions still ocurring in SP2

  Greetings, I have a mining structure that I am using to perform a text-mining classification task. The mining structure contains three models: a decision tree, a naive bayes and a neural network. Both the decision tree and the naive bayes models process without any problems, but I am having significant difficulties with the neural network model. Initially when I processed the model, processing would fail altogether with the following error message: "Memory error: Allocation failure : Not enough storage is available to process this command" This was remedied by taking the steps prescribed in http://support.microsoft.com/kb/917885 (I upgraded to SQL 2005 SP1 and applied all available hotfixes listed in http://s ...Show All