Answer Questions

• Riceroman Export an already rendered report with webservice not using reportviewer

  How do I export a rendered html report using webservice to other formats If I render the report again to other formats, the data in the report might have changed since the first execution. Hi, I don’t know if I got you right at this point, so just for clarification: You already rendered a report and it is present as HTML files and images on your disk. Now you want to take this HTML file and put it in a rendering machine to get something else than HTML, like pdf, etc Not his is not possible, what you can do is to import the data in an Excel file (if the data is structured like in a table) HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- Yes, you've got my ques ...Show All

• OrpheusTheBard Split the file

  my ssis package downloades the text file from Ftp. iT downloades for ex 5 files. I want to split the file to smaller file after downloades. If the size of file is more then 600 mB then I want to split it into 6 files. please suggest if any task in SSIS can perform this or any other way. Two ways I can see how to do this. 1 - Use a Script Task and the System.IO namespace stream objects to read the file and write out into several files. Change files based data size, rows or whatever. 2 - Use a Data Flow, with Flat File source. Then split the flow into several outputs and direct to seperate flat file destinations. There are two ways to do the split that I can think of. You could write a Scri ...Show All

• JRMcFetridge Mix Relative and strict dates

  I am trying to write a report where I can have a drop down with values like yesterday,today,lastweek. But I also want the user to be able to select a specific range, say 7/1/2006 to 7/5/2006. Also why can't i update the value of a parameter through to an expression Like set the value to =Today(). It throws an error about the type. Can someone point me in the right direction here Parameters are typed so you cannot mix relative dates with specific ones. So, you will need muliple parameters and way to determine which ones to use. I would use three parameters, the first one is a drop down with the realative dates and an entry like "Specify." The other two are DateTime parameters for specifying the start and end dates ...Show All

• mesco1 Errors / warnings after deleting variables & Connection Manager objects

  Hi, As I was developing my SSIS package, I created several variables and tasks ( FTP, WMI Reader Task ). I am now cleaning up, deleting unwanted variables and connections in the design window. I save and build the package and when I load the package, I get warnings that these variables are referenced but can't find them and errors that the WMI connection is not found. When a package calls a sub-package, it stores the absolute path of the child package in its dtsx xml file in a Connection String property. How annoying !!! . When I deploy this to another machine with a different file structure, it becomes a problem. Why can't it store the path relative to the parent package, which would be typically in a sub-directory under the paren ...Show All

• Gwyn Williams xp_execresultset equivalent in sql server 2005

  Hello everyone, I would like to know is there any equivalent and/or substitute for xp_execresultset procedure, in sql server 2005. Thank you. Thank you Adam for your time. I'll give some tests on your solution and post you results. Umachandar, I was aware of the fact it is not supported by Microsoft, at the time I decided to start using it. Reason, why MS did not support this procedure is not known to me, but what it can do, is way much better (faster and more simple) then cursor equivalent procedures. Here you go:   http://sqlblog.com/blogs/adam_machanic/archive/2006/10/19/321.aspx   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay ...Show All

• AndrewBadera JDBC Connection question

  Hi, I am using sqljdbc_1.1 and am able to connect / query to my SQLServer 2000 database when I pass the "sa" userID and password in the connect URL. String connectionUrl = "jdbc:sqlserver://<hostName>;databasename=mydb;user=sa;password=********"; However when I pass my username and password instead of the "sa" userID I get the following error (I edited out my userID from the error message): com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user '<userID>'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServer ...Show All

• K.S.RamakrishnaPrasanna Max Record Count and Date Range

  I am currently using this SQL code to capture some records over the last 2 months and it has been working great. I am now being asked if I can change this code with specifications: 1) Scan the records in the system until the count (*) as Volume reaches 30 because they prefer that as a denominator when figuring an average 2) Only run the scan for a maximum of 6 months . So, there will most likely be some records that do not reach a volume number of 30 in this date range. In this instance we will just take the maximum volume number reached at 6 months. So, how can I write this so it will build the file each time a record has reached the maximum of 30 and keep scanning back until we reach 6 months If someone could lead me in the right dire ...Show All

• Vijay_s Deploy Reports via Visual Studio 2005

  This seems to be a basic issue, but I am having a problem trying to deploy a report to Reporting Services. I have setup the deployment options under the properties of the Project. But each time I try to deploy a report, I get "The request failed with HTTP status 504: Gateway Time-out" When I try to connect to connect directly to the TargetServerURL via a web browser from my client or the server itself, I can browse the structure fine. Not sure why I can't deploy via Visual Studio. Thoughts Thanks Are you still getting the same error If you are on the same subnet, the request shouldn't be using a gateway. try opening a command window and ...Show All

• e-maurizio can't download ms sql 2005 free trail version

  hi was looking forward to downloading the 180 day trial version of ms sql server 2005. Signed up and everything. when it loaded the download page it only has the 2 help files listed. Has the free trial ended if i download the full express version does that have a free trial info@uktattoostudios.co.uk Pending limit exceeded If you are still unable to receive the Verification E-mail after three attempts, Contact Us I have already registered and confirmed but still cannot download it from the link provided. keeps on having the above error. Please help Mabbuuuuuu Hi, SQL Server should be downloadble at: http://www.microsoft. ...Show All

• Handerson Package ID "not available" in Management Studio

  Do you need certain file system permissions for the SSIS service account to view the Package ID (a guid) in management studio When viewing Stored SSIS Packages in Management Studio's Object Explorer, the Package ID for a given package is always listed as "Not available". This applies to .dtsx files stored on the file system (SSIS Package store). Conversely, for packages stored in MSDB (Sql Server), the Package ID is listed. P.S. The version major, version minor, and version build number are also always "0" for packages stored in the Package Store when viewed through management studio, even though they are clearly not zero when loaded in BIDS. windows xp sp2 SSIS version 2153. The ...Show All

• Patricio Merino D&amp;#237;az Replication and distribution: Agents

  Hi all replication experts... I have created transactional replication on my servers (production server and backup server) and created pull subscription at the backup server. On my production server that also is a distributor and publisher there exist two agents, Snapshot agent and Log reader in the Publishers folder under replication Monitor. There are also another agent with the backup server name and database name: BackServ:DBName having the type Pull and 'No replicated transactions are available' as Last Action. My question is: What is this Must it be there Grateful for answers Best, /M OK, thanks :) Its hard to say exactly what this is, but it appears t ...Show All

• samujob Question transport-level error

  Hi all, I'm having a little problem with my sqlserver 2005. I'm trying to crate a user in Microsoft SQL Server Management Studio throug a query. Like this: ------------------------------------------------------------------------------------------- USE [master] GO CREATE LOGIN [MYUSER] WITH PASSWORD = N 'MYPASSWORD' , DEFAULT_DATABASE = [MYDB] , DEFAULT_LANGUAGE = [us_english] , CHECK_EXPIRATION = OFF , CHECK_POLICY = OFF GO ALTER LOGIN [MYUSER] ENABLE GO USE [msdb] GO CREATE USER [MYUSER] FOR LOGIN [MYUSER] ; GO GRANT EXECUTE ON [sp_start_job] TO [MYUSER] GO EXEC sp_addrolemember 'db_datareader' , 'MYUSER' GO EXEC sp_addrolemember 'db_datawriter' , 'MYUSER' GO EXEC sp_addrolemember 'SQLAgentOperatorRole' ...Show All

• nhaas CREATE DATABASE permission denied in database 'master'

  Hi, I'm using Visual Studio 2005 Pro and SQLExpress that comes with it. I have my program running fine in XP Pro OS using a window user "Glen" (Computer administrator) with Administrator rights. This means that I installed VS 2005 using this window user "Glen" I created another windows user "TestUser" (Limited account) in the same physical PC. I tried to run the program and on the part that I need to access SQL table, I got the error [CREATE DATABASE permission denied in database 'master'] At the same time while using "TestUser" and running sqlcmd (to check if I can connect to SQL), I also got error HResult 0x2, Level 16, State 1. I read alot on MSDN discussions and related links bu ...Show All

• Wicket CONDITIONAL SPLIT Assistance

  i need to use a conditional split transformation to find missing column and direct the output of conditional split to my destination. I have the following columns PatientId, Allergycode, SeverityCode My requirement is to check whether value of a particular column is null or not null. Please help. Ronald What part is a problem Have you looked at transform documentation http://msdn2.microsoft.com/en-us/library/ms137886.aspx To check for null values use IsNull method :) http://msdn2.microsoft.com/en-us/library/ms141184.aspx My conditional Split has 14 outputs. The conditional Split default output is connected to the data conversion. Yes, I have monitored the data flow during execution. No, it does not. ...Show All

• deen 'sa' User Map error

  Hello all, I'm having a problem with my sa account, we just migrated from sql server 2000 to sql server 2005 and 1 of our production applications is failing on the sa login. I checked the 'User Map' setup to the 'sa' account and the databases that need accessing aren't mapped. When I try to add the map, I get error "Cannot use the special principal 'sa'. (Microsoft SQL Server, Error: 15405)". I get the same error when trying to remove a user map for sa (there are a couple db's already mapped), and I don't remember how I mapped them in the first place, but it certainly isn't working now! Thanks in advance, 102020 What is ther error that you get back and for waht operation do you get it back Pl ...Show All