Answer Questions

• Kevin Riley Quick search algorithm in database

  Hi, I need in my app. a good search option in datafields of dataset. Maybe someone can help me find an algorithm WHat do you mean by a lagorythm for searching in datafields Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- Create a DataView on top of one of the DataTables in your DataSet, and set the Filter property of the view. Would that help Thanks, Marcel van der Holst [MSFT] ...Show All

• scoman81 Changing a SQL 2000 CD Key?

  My company has recently sold a part of its business, and along with that business goes a live SQL 2000 server. However, the license for said SQL Server was not part of the sale. So, to make a long story short I've been tasked with finding a way to A) change the license key of the existing installation to the new owner's license key while B) keeping the existing installation intact and running. Now I've done enough digging to know exactly where the key info is kept in the registry (in HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Registration), but I'm more than a bit leery of changing the key at the registry level without confirmation that it will work. I do have a test server I can use as a test if necessary, but I'd prefe ...Show All

• aabundez RS 2005 hangs

  I am running rs 2005 and I created a test report but it hangs when I select it on the report manager. The weird thing is that I can run the report through the reportserver, but not on the report manager. Has anyone experienced this problem Thanks, I've seen something similar before myself. I found that when using the preview window, RS pulls the data and caches it into a file in your report solution directory called "report_name.rdl.data". This is useful in development when messing around with various options and formatting as RS does not have to re-execute a potentially lengthy query and generates the preview from cache. When you deploy the report it will run the query every time the rep ...Show All

• Vijay Singh Is there something similar to SQL 2005 row_number() in sql mobile?

  Hello, I am wondering if somone could provide me with a sample SELECT for an auto number query. For example I have a table called People with two columns first_name, and last_name. There isn't a unique id to correspond with the table but would like to dynamically make one during the return of the query. I know this is possible in the full version of sql 2005 using SELECT ROW_NUMBER() OVER (ORDER BY last_name), first_name, last_name from People But within sql mobile is there a way So if there was 5 rows in the table it would return 1 John Alpha 2 John Beta 3 John Cat 4 John Delta 5 John Echo John No SQL Server Mobile/Everywhere Edition does not support Row_Number() and there is no sim ...Show All

• Lewis Yeung Text Orientation

  Can SSRS2005 format text orientation vertically (or at an angle), like Excel can, in a table or matrix region hi Kory, the writing mode property can do a vertical slant, not sure how you do angles. Click on the textbox you want to change, go to the properties window, scroll down to "Writing mode" and select "tb-rl" the change is only visible on running the report, not design mode cheers, 99 this is working in preview mode and also when i export it to pdf....but i couldn't get it to work with IE (Version 7.0.5700.6) is there a workaround btw: i have a lot of layout issues with matrix and IE.....in preview everything seems to be right but after ...Show All

• AlexBB How to use variables for server connections

  Hello, Today is day two of using SSIS and having some issues adjusting. In DTS I would simply populate my global variables via an Active X step or pass them in at the job line. I am having a hard time being able to do either or in SSIS. Really all I want to be able to do is pass in a server name to the Connection of an execute SQL task from a scheduled job line. Same goes for any variable really ... how do I pass them in, and how do I assign them to specific areas of a task Thanks! Mr.Bean wrote: I think I follow you on that ... but the fact is that I have to create a connection in the connection manager for the task to refrence correct Correct. Mr.Bean wrote: So th ...Show All

• Musafir Execute SQL Task: Error

  I am running a Execute SQL Task which runs a script on a table. It gives me following error: [Execute SQL Task] Error: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_SingleRow". Thanks, http://msdn2.microsoft.com/en-us/library/ms141003.aspx Your query in the execute sql task is returning more than one row. Pretty much just what the error states. If you don't need to return the results of the query to a variable, select "none" instead of "single row" in the ResultSet box. If you do in fact need to return more than one row into a variable, you'll need to select "Full Result Set." The variable you populate with single row needs to match (or be ...Show All

• eddy2705 A lot Of Questions!!!

  Good Morning.. i have started developing on DTS recently. and i have a few question about "How-To" issues. Hope you guys can help 1) I noticed, whenever i want to "redirect row" whenever an error happen, i need to set my AccessMode to OpenRowSet... This mode as i noticed, cant be used when i am tranferring data into a sql table which has primary key set e.g. Ms Access which has identity -> SQL table with PK set Is there anyway, to capture the row error in my situation 2) Another question is, in a data flow... can i have a source which has multiple output arrow. Sorry for the inconvenince,Thank you in advance Hi Phil thanks for the fast reply I am ...Show All

• Swupp Ole DB Destination - Fast Load - Permissions

  All, If I use an OLE DB Destination with Fast Load, and enable check constraints, I would expect to see this work as BCP would in this scenario on 2005. However, instead, I get the error ALTER TABLE permissions required. I understand that when using BCP, if you disable check constraints and triggers, then you need alter permissions. But, when you explicitly enable these, then you do not need this permission. I would expect the same behaviour in SSIS, but I am not seeing it. Fast Load seems to always require ALTER TABLE permissions. Can anyone confirm/deny this Thanks, dcb99 dcb99 wrote: Phil, I've tested with with the constraints checkbox checked and without. (The other checkboxe ...Show All

• Tomas Restrepo MVP Problems.......

  I have a string parameter that is set to multi value. @PONUM There are no entries in the mvp box, the user enters them at run time. Problem is, I can't the the damn thing to work right. I am also using a StartRange and EndRange which works just fine. Can someone PLEASE help me out. Here is my query. If RTRIM(@PONum) = '' OR @PONum IS NULL Begin SELECT r_PurchaseOrder_1.PO, r_PurchaseOrder_1.PODescrip, r_PurchaseOrder_1.PayTerms, r_PurchaseOrder_1.DeliveryContact, r_PurchaseOrder_1.DeliveryAddress, r_PurchaseOrder_1.OrderDate, r_PurchaseOrder_1.Company, r_PurchaseOrder_1.SupplierName, r_PurchaseOrder_1.OrdFrAddrLine1, r_PurchaseOrder_1.OrdFrAddrLine2, r_PurchaseOrder_1.OrdFrAddrCity, r_PurchaseOrder_1.OrdFrAddr ...Show All

• logtorahul SSIS package works, but not in SQL Server Agent job

  I have a problem running an SSIS package in a SQL Server job. The package runs fine if I run it from the MSDB location, but if I try to run the job it fails. The job is set to Run as: SQL Agent Service Account. The SQL Service Agent service runs as a domain user SQLExec. I have logged in as this user and run the SSIS package and it runs fine, but if I create a job with only this step it fails. There isn't much information about where there is a problem. Any ideas or ways to troubleshoot this problem would be very much appreciated. Thanks, john What is your package ProtectionLevel property set to If it is default (EncryptSensitiveWithUserKey) - then that might be the problem Make sure you enabl ...Show All

• e.henriquez URGENT - My error or Bug? The result of the expression cannot be written to the property. The expression was evaluated, but

  Error 3 Error loading MLS_AZ_PHX.dtsx: The result of the expression ""C:\\sql_working_directory\\MLS\\AZ\\Phoenix\\Docs\\Armls_Schema Updated 020107.xls"" on property "ConnectionString" cannot be written to the property. The expression was evaluated, but cannot be set on the property. c:\documents and settings\viewmaster\my documents\visual studio 2005\projects\m l s\MLS_AZ_PHX.dtsx 1 1 "C:\\sql_working_directory\\MLS\\AZ\\Phoenix\\Docs\\Armls_Schema Updated 020107.xls" Directly using C:\sql_working_directory\MLS\AZ\Phoenix\Docs\Armls_Schema Updated 020107.xls as connectionString works However - I'm trying to deploy the package - and trying to use expression: @[User::DIR_WORKING] + "\\D ...Show All

• Flame Sword8 Constraint Problem while Generating Script in SQL2005

  I created two table; a perent and a child, and add a constraint. I set "Enforce Forign Key Constraint = No". I generated script of that database and run it on another server. It autometically set "Enforce Forign Key Constraint = Yes". Is this a bug in SQL Server and what should I do to resolve this problem ...Show All

• Java dude... Detailed description on creating a dynamic excel file

  Is it possible that i can create a dynamic excel file (destination) ex, i want to create a Dyanamic Excel destination file with a filename base on the date this will run on jobs. Is this possible 11172006.xls, 11182006.xls This example is useful for loading data from an OLEDB source into a dynamically created Excel file. NOTE: This is the core functionality. Things like logging, checkpointing, documentation, etc., are at the user's discretion. Steps: 1. Click on package properties. Set " DelayValidation " property to True. The package will not validate tasks, connections, until they are executed. 2. Create a package level variable " XLFileRootDir " as string and ...Show All

• Rob Wheeler Displaying images from SSAS data source

  I'm trying to display the images from the Adventure Works SSAS database in a SSRS report. I've added an image object to the table, set MIME to image/jpeg (as it is set in the value fiel of the attribute in AW SSAS database) but I'm getting just a 'x' instead of the image and following output: Preview complete -- 0 errors, 1 warnings [rsInvalidExpressionDataType] The Value expression used in textbox ‘LargePhoto’ returned a data type that is not valid. Preview complete -- 0 errors, 1 warnings [rsInvalidExpressionDataType] The Value expression used in textbox ‘LargePhoto’ returned a data type that is not valid. Preview complete -- 0 errors, 1 warnings [rsInvalidExpressionDataType] The Value expression used in image ‘image ...Show All