Answer Questions

• bluntcoder Script Task TimeOut

  Anybody knows how to change the TimeOut of a Script Task Thanks! The script task doesn't have a timeout setting. I would expect that you could set a timeout in your calling code can you not Perhaps if you posted your code and the errors people would have a better chance of helping you. -Jamie The code of the Script Task is: Public Sub Main() Dim myWebClient As WebClient ...Show All

• EthanLiew Metadata storage and intelligent use

  I am contemplating moving a huge integration project (hundreds of different medical practice management systems) from a competitor's dedicated data integration tool to SSIS.  One of the main questions I have about SSIS regards it's capability to maintain - and even more importantly - intelligently use metadata regarding source and target data in the integration processes. One significant example: There is an ETL tool that I am fam ...Show All

• Lau Han Ching Updating data

  Hello. Is it possible to somehow update data as it is copied from source to destination using SSIS. Currently I extract data from Database A, load it into database B, then clean/update the data in database B and then load it into database C using DTS on 2000. What I would like to do is extract data from database A, clean/update it, then load it straight into database C without having to load it into database B first. I am unable to c ...Show All

• Joost Ploegmakers Restrict User Access in MSSQL 2000

  Hi, I have few SQL user who has permissions on different databases. When they are accessing MSSQL server from Enterprise Manager they can see all Databases but can not access them and they can change file size allocated to them. I want to restrict this and they can only see database belongs to respective user and restrict user to change allocated size. Please help me with this as I am not able to find the solution. Thanks & Regards, ...Show All

• Obscurity Connect to remote RS in SSMS

  Got following error when try to connect to remote reporting service in SSMS: TITLE: Microsoft SQL Server Management Studio ------------------------------ The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient) ------------------------------ BUTTONS: OK ------------------------------ No problem to connect to reporting service in SSMS on RS box locally. Use windows authentication with same ...Show All

• Odysseus No witness, primary shutsdown, bring failover online

  First of all, Great webcast today. My question is, I have everything up and running and would like to know what to do when the machine my primary is on quits or has a some type of disaster. Do I need to manually run recovery on each db that was mirrored I'm not currently running a witness. thanks This is correct. If the principal cannot be contacted, then the way to make the databases available on the mirr ...Show All

• David Carlson MS How to recover Database from .MDF

  Hi there,   I lost my .LDF file. Is there a possibility to recover Database from the MDF file with all data and Stored procedures Im using SQL Server 2000.   Please help....and sry if this is the wrong Forum for it...   Thx T. Gnewuch   Try to use sp_attach_single_file_db, it can recreate the logfile if the database is not corrupt. HTH, Jens Suessmeyer. --- http://w ...Show All

• wadleys rsExecutionNotFound

  I can preview a report I've written in VS (BIDS) without error. However, when I've deployed it to the report server, I'm unable to execute the report. I receive the following error: Reporting Services Error Interesting.  I'll try your suggestion as soon as I get a moment. Thank you for the (very quick) response. -- wall (I happened to log in to this forum as xguy this time) Hi Kevin. I h ...Show All

• Vlad Pitaru sql server 2005 error handler

  At present There is a stored procedure with several sql statements. Each one has a standard sql 2000 error handler. i.e. after each statement there is a if @@error > 0 ... does this mean that I have to place a begin catch instead of each present (if @@error > 0) Or, how can I use the begin try...begin catch... which replaces what I have at present (i.e. several if @@error > 0) Thanks TRY..CATCH ...Show All

• GeneSegal Assigning one text box value to the other text box in the sql reporting services Form

  Hi, Can some one help me in this case, I am manipulating a value for onetext.value , And I want to assign like this seconetext.value = onetext.value in the SQl reporting services form, Is it possible if so can any one help me with the syntax -Thanks Yes, this is possible. In "seconetext", use this expression: =ReportItems!onetext.Value -Chris ...Show All

• RpM Unable to access MSSQLSERVER from client

  Hi, I have SQL Server 2005 installed and functioning (it does everything I've asked it to do locally). I also have the Express and Standard Editions installed on a computer running WinXPPro SP2 with all the WinUpdates applied. I also have VS2005 installed on this computer. I've done some development work on this computer, using VS2005 to create a SQLDB, connect to it, add data, etc. This is all okay. The problem is I cannot connect to the& ...Show All

• DeepakBakshani scale greater than precision - not a valid instance of data type real

  Our shop recently upgraded to MS SQL 2005 server from the prior SQL 2000 product. I receive and error during processing related to inserting a value into a field of datatype real. This worked for years under MS SQL 2000 and now this code throws an exception. The exception states: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 15 ("@TEST"): The supplied value is not a ...Show All

• Tinus Groenewald Problem with Hyphen in server name?

  Hi all, My sql server has a hyphen in its name, and I've noticed I can't use a fully qualified reference, server.database.owner.table. Is this a known bug , what's the fix apart from renaming This is standard version, not a beta. Hi Meltdown, this is anugly things having a hyphen,or any other character in the server name, but putting brackets around that should solve the problem. [server].database.owner.tab ...Show All

• Bipul Join problem

  hi I have got two tables and each table has about 8000000 rows.. the format of the tables is as follows.... Table 1 Comnpany_name Id Year Volume_jan Volume_feb....... Volume_dec ABC 1 2000 12 34 44 ABC 2 2000 222 50 44 .................................................................................................................... ...Show All

• RFaircloth Multi value string parameters

  Hi all I have a multi value drop down list and their values are a string data type. Label      Value Blue        BL Pink        PK If I select more than one values the parameter value is sent as 'BL, PK' The stored procedure has a where clause WHERE theColor IN (@SelectedColor) This does'nt return the expected results from the stored procedure. H ...Show All