Answer Questions

• Wa5h Reporting Services 2000 web-services rendering

  We are using Reporting Services 2000 and we have a project in which we need to implement a security layer in a customized ASP.NET application to authenticate and authorize requests to view reports. The client's needs are secure / restricted access via the public internet, all requests must go through the ASP.NET application (the report server URL must NEVER be visible) and the client must be able to print the report using the special Acti ...Show All

• JamieHiggins How to convert Oracle Database to SQL Server Database

  Hi all, how i can convert the oracle database (tables, precedures, sequesnces, ) to sql server database, i would appreciate if anyone give me the step by step process of conversion. Reagrds Ramesh Jha Hi, tables and other entitites can be imported using the Import wizard. But procedures which include PL/SQL code have to be either imported using a migration tool or manually by recoding them. At the end of the day, I guess ...Show All

• Kari Ko Transactions mode

  I have a package that uses only transformation tasks like Lookup, Merge and Slowly Changing Dimension.  I would like to rollback all the INSERTs or UPDATEs done if an error occurs (like dup key). I understand the different transactions modes (Explicit, Autocommit, Implicit) but I'm not sure how to use it within an SSIS package.   How can I associate a transaction mode to a connection   Is there a property for it   How do ...Show All

• Rob Bowman SSIS not detecting Oracle Stored Procedure failure

  Hi, I figured out a way to execute an Oracle Stored Procedure from an Execute SQL Task by using Declare Begin SomeStoredProc( , , ); End; with an OLE DB connection using the Oracle Provider for OLE DB. The parameters are getting passed in and the procedure executes but if for some reason it fails SSIS is painting the task green and keeps processing. I'm guessing that's because the outer Declare/End statement completed sucessfully. ...Show All

• fudata Same header in different reports

  Hi! I would like to use the same header in different reports. Is there anyway I can do this without copy/past all the textbox/images Can I save the header in a file and import it, for example Thank you! You can try using a subreport to do that. The subreport would contain the header. And add the subreport to the location in the reports you want to place the header. ...Show All

• Nick Efremov Complex join

  I have a C# application for tracking training. When I need to get the employee's missed training (exception report) it works fine on a one-by-one basis. Our HR folks can't sit and spin through 100s of screens, so I want to provide a comprehensive report for all employees. Here is the first hack which places everything into a temporary table. Problem is I can't get a while loop to work with it as is. All three "sub queries" build the ...Show All

• The Unknown 7 SQLSERVERAGENT not starting (urgent please)

  Hi All, I need a help here please. I have a sql server 2000 running on windows server 2003. I run the services (MSSQLSERVER,SQLSERVERAGENT) under a local user which has no admin right. This local user named "sqlsvr". The configuration that i used to make the "sqlsvr" able to run the services is in this web address : http://support.microsoft.com/default.aspx scid=kb;en-us;Q283811 After im able to run the servi ...Show All

• llorrac Linked Server

  Hi all, How can I add linked server from SQL Server 2000 database to a SQL Server 2005 without using SQL Server trusted connection. I will use certain credentials. Thanks Jens. This was very helpful. Did you had a look at the BOL sp_addlinkedsrvlogin (Transact-SQL) "Creates or updates a mapping between logins on the local instance of SQL Server an ...Show All

• hackwrench exposing proprietary data to SSIS (Newbie alert)

  Hi all, I've exposed my data (that exists in a proprietary format) with the ADO.NET provider interfaces (IDbConnection, IDataReader, IDbDataAdapter and IDbCommand). I can't seem to find any examples of how to get Integrated Services to hookup to this .NET code in my class library. Is it possible My goal is for this provider to be both a destination and a source and for others to be able use IS to manipulate the data however they want. Som ...Show All

• danielches Shared Data Source problem...

  Scenario: I've created a "New Data Source" via Report Manager. But, my report doesn't recognize that data source. Why When I view the "Reports" tab of my DataSource in Report Manager...it says there are no reports using this Data Source. Why As a side note...I should mention that the "New Data Source" created using Report Manager has the exact same name as the .RSD file created using Visual Studio. Sho ...Show All

• Michael_Guinto Reports run under my credentials, not those stored on report

  I've created a report in SSRS 2005 that sources from a SSAS 2000 cube (on another server). In BIDS (running on the SSRS 2005 server) I'm using a shared data source with "generic" credentials to access the data. The generic credentials I'm using is an account that has datareader access. In BIDS the report runs, builds and deploys just fine. No problem so far! My problem has to do with running the report from the Report Server. The on ...Show All

• wolf777 how to appoint a time Parameter dynamic default member in ssrs05 ?

  Precondition: 1 my data resource from olap time dimension 2 i know 'Tail(Filter([time].[day].Members, NOT IsEmpty([time].CurrentMember)),1).Item(0)' in mdx. my question: how to implement the same function like Precondition2 in ssrs05 ...Show All

• Paul44 problem connecting to datatbase via c# express

  I have a problem connecting to all databases via c# express.the error message says 'failed togenerate a user instance due to a failure in copying database files. The connection will be closed' I am using SQL server 2005 express with managment studio express and visual C# 2005 express. Hi there, A few other people have experienced similar problems to this one (I've never had this one myself though). The solution seems to be to delete t ...Show All

• RGabo how to use word and pdf filter in full text search (SQLServer2k5)

  where to find and how to use full text search service to index word and pdf documents. please point me to a tutorial or give a step by step instruction. thanks for reading. http://www.codeproject.com/csharp/fulltextsearchingifinters.asp ...Show All

• Juan Carlos Velez Multiple Filegroups

  Hi experts, I'm new to SQLServer 2000 and would like some advice on filegroups. Is there any advantage to seperate the filegroups for different type of data. For example: Data_1 for tables Index_1 for Indexes Audit_1 for Audit tables The files for these filegroups would be placed on RAID Disk. Thanks for any suggestions. Any comments I need to know whether there are any performance gain in seperating types of data in different filegrou ...Show All