Answer Questions

• zydjohn Configuration of RSreporthost

  Hi, having used the most of my day trying to do this - i have to ask. Is there no way to config this tool to get the same permissions as the vs.net preview I have a strong name assembly who read the System.Environment.username - and it won't run in the rsreporthost. Please help me out here.. I've got it right now... I had a restart (mentally) and now it works. For the record, I've added a permissions ...Show All

• AdKhan SSIS Requests...

  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

• Jivko Dobrev - MSFT Making SSAS Developer Edition act like standard edition

  My understanding is that the Developer Edition of SQL/SSAS contain all of the functionality of the Enterprise Edition. Is there a way to force it to act as if it were Standard Edition (and therefore subject to all of the limitations of SE) The reason I ask is that with our product we're trying to maintain compatibility with both SE and EE. I realize I can just install SE instead of DE, but if there's a way to simple toggle the behavior, that wo ...Show All

• SWMagic Decoding Decimal Form of HRESULT from ErrorCode

  I have an OLE-DB Command transformation that inserts a row. If the insert SQL command fails for some reason, I use the "Redirect Row" option to send the row to another OLE-DB Command transformation that logs the error on that row to a "failed rows" table. In this table I log the ErrorCode and ErrorColumn values that come with the error path from the first OLE-DB Command. OK, that's all working great. However, here's the kicke ...Show All

• Utku UZUNDUMLU Are there tools available to extract summary text from data in a varbinary(max) field?

  This is related to the previous question.... I can create fulltext indexes off document data and query the data. But when displaying the result set I want to show a standard short document summary, or better yet a summary that shows the keyword in contexts within the document (like google). Are there any tools available that allow me to do this. Can it work right from the varbinary(max) field or does the document first need to be extracted to ...Show All

• Tina Tam - MSFT The subscription to publication is Invalid

  Hi, I have two SQL 2000 Server running on Windows 2003 Standard Edtion. I am using merge option to replicate database as Transactional option is excluding some tables. Both server are not in Active Directory and I am trying to replicate over the internet. I got following error message while using Merge option: Error Message: The subscription to publication 'XXX' is invalid. Error details: The subscription to publication 'XXX' is i ...Show All

• Dan.G Ad hoc updates to system catalogs are not allowed.

  in SQLServer2005 how can I allow update system catalogs (by mouseclick) sp_configure 'allow updates' , 1 - works, but I get the message Msg 259, Level 16, State 1, Line 1 Ad hoc updates to system catalogs are not allowed. I believe you can do exec your_db.sys.sp_rename to make sp_rename execute in your_db. Also if you do "use your_db; sp_rename", this will be equivalent to above. Most of system sps were moved to resource database ...Show All

• newSB SSIS Changing Column Order during Transformation

  First let me say, I really can't believe this chain of events myself--and they are happening to me. I am upgrading several DTS packages to SSIS on what will be my new production server. These packages create tables, export them to a flat file, and ftp them off to other locations. What is happening (on the SSIS side) is that the OLE DB Source is reordering some of the columns on its own (moving them to the end of the table/file. Then when m ...Show All

• bpearson Report Model Deployment Problem (DataSource)

  I created a new Report Model project and specified folders for both the model and the datasources.  For some reason, every time I deploy the model I get an error stating the datasource cannot be found. I've tried changing the project properties to no end.  Here's the specific output Deploying to http://localhost/ReportServer %2f Deploying data source '/Data Sources/CRM Database Conection'. Deploying model 'CRM Filtered View Model'. ...Show All

• Syed Afzal Ali Can't connect to Report Server via Management Studio

  Hi, I have a local installation of SQL Server 2005 (Developer Edition) on XP Professional SP2, with Reporting Services, Integration Services, and Analysis Server installed. I can connect to Integration Services and Analysis Server via the SQL Server Management Studio, but not to the Report Server. I can access and use the Report Server installation via http://localhost/Reports and http://localhost/ReportServer , and everything checks out on ...Show All

• Sameer.S Usage of Raw File in SSIS

  What is raw file in SSIS, could you tell me samples for usage of raw file Oh please. Did you even bother to look at the links above You need another data-flow with a raw file source adapter and then you treat the data as you would any other data in the data-flow. -Jamie We have completed upto move to flat destination files using raw files, could you please help to move this flat files data (for up ...Show All

• Gilles BECAVIN MSmerge_genhistory error-515

  Can't insert value NULL into column nicknames. This error generated when I try start sync. SQL Profiler is not helping w/ locating specific error. I tried to allow NULLS in nickname column, for this table, but this table gets dropped and recreated each time. Pls. advise on where to make correction. thx..bt After the publication deletion process and getting same error 515, I did the following ...Show All

• CCusson15 fatal error 7105

  hi guys, does anyone know what would have caused this error happened: [microsoft][ODBC sql server driver][sql server]warning:fatal error 7105 i have check with microsoft technet and it said: Page %S_PGID, slot %d for text, ntext, or image node does not exist. thanks. best regards, kharulli Hi, these datatypes are stored as pointers. It seems that your pointers are pointing to orphanded pages, so you can 1. Check the SQL Server log to see ...Show All

• Jayplus Formatting page header in Excel

  I want to simplify the spreadsheet layout when our reports are Exported to Excel to make data analysis easier and have tried using SimplePageHeaders=true to put the report header information into the Excel page header instead of rows repeated on the worksheet. This does what I want as far as the improved worksheet structure is concerned, but I have a few queries about the header : 1. Is it possible to alter the header margin in Excel - cur ...Show All

• Budoray Error using Datareader Destination

  Hi guys, I'm in dire straits here - really hoping someone can help me. I'm using a datareader destination and consuming it in a C# app. When I fire ExecuteReader on my DTSCommand object to return some data I get the error: "Could not obtain a datareader object from the specified data flow component" So we don't have a clue why this isn't working. Although...I'm intrigued by the line about "specified data-flow component". In the C# app you d ...Show All