Answer Questions

• Stealth549 Updating Data in Oracle

  Hi, I'm very new to SSIS so excuse any ignorance... Im trying to update a set of records in an oracle table based on the results of a query against a SQL Server 2005 table. I would prefer not to run the update query for each result in the source query (but will do it if only way possible), so I have built a script task which builds a comma separated string of Ids that I can use in an in clause... Hence the query I want to execute is of the form: update MyTable set STATUSID = 2 where ID in ( 3,4,5,6 ) When I try and execute this query using an 'Execute SQL Task' in debug mode the package gets 'Stuck' on this task. The task turn yellow as though it is executing but never continues - no errors either. Is it possible to execute an Update s ...Show All

• bkizzy Problems with OraOLEDB.Oracle

  Good day everyone.... I have installed the OraOLEDB.Oracle Provider on 3 different servers, and have made a link server on all three. On two of the machines, I am successful in retrieving data from the Oracle database. But, on the third machine, I receive this error: Server: Msg 7399, Level 16, State 1, Line 1 The OLE DB provider "OraOLEDB.Oracle" for linked server "employee_prod" reported an error. The provider did not give any information about the error. Server: Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "tims2_prod". On the machine which is generating the error, I can use SQL*Plus to connect to th ...Show All

• Biceps Inserting to Dimension on Failed Lookup

  First, I'm very new to SSIS, so forgive any stupid questions. I'm trying to normalize some data by creating rows in a dimension table as I find new values in the original table. My first thought is to use a Lookup to replace string values with id's to the Dimension table, and when the Lookup fails, insert the value into the Dimension table with a new key. Does that make sense This would be relatively easy to do with TSQL, but surely there is a way to do this in SSIS. Thoughts OK. Thanks alot. I appreciate your advice. I read that thread, and the example that Thomas Pagel blogs on is what I'm looking for... however, this really seems like an unnecessarily complicated approach. Since I'm new to this, I'm inclined to thi ...Show All

• Endo64 There must be an easier way - Dupe check and Increment field

  Greetings all, I have a bit of brainteaser that's going to take some serious thought. I'm importing information from .xls files into a SQL table. The problem is I need to check for dupes and increment certain fields on success of dupe find and then not insert or delete the dupes. For example, if I have Adam, Turner, 32, 50 already in the table and someone tries to insert Adam, Turner, 32, 50...I need it to increment to read Adam, Turner, 64, 100 and not insert the record. (Notice 2 fields were incremented.) With that, I have created an INSERT trigger as follows: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER Trigger [dbo] . [trgInsertCheck] ON [dbo] . [MyTable] FOR INSERT AS BEGIN  &nbs ...Show All

• Vedratna SQL 2005 Cluster Error

  We are getting the following error messages on a regular basis. [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]TCP Provider: An existing connection was forcibly closed by the remote host. [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]Communication link failure [sqsrvres] OnlineThread: QP is not online. [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect faile ...Show All

• Michael_317 Custom Semi-Transparent bar charts?

  I know that SSRS 2005 has a built-in semi-transparent color chart palette, but I'd like to define my own custom color semi-transparent palette. Brian Welker's blog ( https://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx) has a terrific post on how to create your own custom color palette, but it generates solid colors. How can it be tweaked to create semi-transparent colors Is there another function that needs to be created to define the transparency of the color palette Thanks in advance, Pete Hello Thor: Interesting... I'm a little confused, though. Is your code affecting the Dundas charting component or are you suggesting a way to create charting transparency in reporting services ...Show All

• enric vives Page Breaks erratic in VS 2005 ReportViewer

  I deploy a 2005 ReportServer Report, and view it in VS2005 ReportViewer. Except for very simple reports, the viewer will show hundreds of rows without a page break. This causes performance problems when the user changes a report property and re-renders. Specifying a page break at the end of each group is not a good option, because it breaks up the normal viewing of the report. I just want the report viewer to do a page break every 8.5 inches, just as a printer would. Is there some way to specify a maximum page length for the viewer Fooling with the report's interactive size doesn't seem to have any effect. Thanks for your ideas! ...Show All

• pckaw600 Get last record in a SQL database

  Don't know if this is the right SQL section, but... using VBE, how do you SQL for the last record in the database Thanks. This is the answer. Thanks to you Edward E. Weller If you want to select the last ROW inserted in a TABLE in a DATABASE that has an IDENTITY column named ID, you could use the following: SELECT * FROM    TABLE WHERE  ID = IDENT_CURRENT('TABLE') or SELECT * FROM    TABLE WHERE   ID = (SELECT MAX(ID)  FROM TABLE) I hope this helps. Sincerely, Edward E. Weller select top 1 * from TABLE_NAME  order by ID desc isn't is what you're asking for I ...Show All

• chris441962 MS SQL 2005 performance issues

  After migrating to 2005, I started noticing some performance problems with my queries. Here is one of them. The query takes some 40 seconds to execute for the first time with intense disk operation. Next time I run it the result comes back in less than a second. however, if I make a minor change to one of the parameter, it takes ~25 seconds with 100% CPU utilization and 0% of disk utilization. So, I'm assuming that all data has been cached, but I can't imagine why it takes so long to retrieve data from the memory BTW execution plans look completely identical for those queries. Here is the query example: select quotes.quote_id from indicators indicators_1, quotes, quotes quotes_1, quotes quotes_2, ranges ranges_1 where not (1. * q ...Show All

• Eduardo Alvim I can't seem to find exactly what my problem is in the following

  I have trying to figure out where the error is exactly. The error message shows a '/' and there isn't one of these in my stored procedure at all The error is: Msg 102, Level 15, State 1, Line 5 Incorrect syntax near '/'. Here is the rather lengthy code. set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo] . [TEST] @StartDate DateTime , @EndDate DateTime AS BEGIN SET NOCOUNT ON ; DECLARE @sql varchar ( 8000 ), @select_clause varchar ( 8000 ), @from_clause varchar ( 8000 ), @gift_clause varchar ( 5000 ), @is_welcome bit , @pckg varchar ( 100 ) declare @bk_id int , @it_id int , @qty int , @desc varchar ( 100 ), ...Show All

• mario gutierrez Licensing sql express for web hosting providers

  For the second time in as many months I've been asked the question. What is the license requirement for me, the service provider, for offering my clients the ability to use SQL Server Express I understand the license to say that as long as I'm registered (no cost) there is no further licensing needed in order to offer this to my clients. Could someone clarify this for me If I'm incorrect I'd appreciate the right answer. Thank you! Anyone I could sure use the help You can use SQL Express for Web Hosting, you just can't rent, lend or lease it as a standalone service. Please be sure to fill out the Redistribution Registration at http://www.microsoft.com/sql/ed ...Show All

• Cavetroll Checking Job Status using T-SQL

  Hi. How can i check the job status using SQL Query I tryto change the SP_HELP_JOB but its too complicated, Is there any other method so i can insert all things into temp table and select current_status from the temp table. I guess I don't understand why you think sp_help_job is so complicated. You give it a job name, and it gives you a status. Actually, very simple. by the way.... What is meant by JOB STATUS The problem with using sp_help_job in a batch is that you can't return the results to a table. This is because sp_help_job itself returns results to a table as part of its processing, and An INSERT EXEC statement cannot be ...Show All

• PJFINTRAX Error: 'The DbpropMsmdMDXCompatibility property is not overwritable'

  I am getting the error: "XML for Analysis parser: The DbpropMsmdMDXCompatibility property is not overwritable and cannot be assigned a new value." when I try to connect to an AS2005 cube through http using Office 2007. I can connect to the same cube fine with other clients. Any ideas how to approach this issue MDX Compatibility Mode is a session property and cannot be changed from command to command. What you describe here sounds like a bug inside connection pooling in msmdpump.dll - perhaps somebody connected with non-default value for MDX Compatibility Mode, and his connection is being reused for your session. ...Show All

• BilalShouman Onerror Event Handler

  Is the Onerror Event Handler from the tabbed window in the IDE the same as the red arrow paths that can be used in the control flows and Data Flows If yes, what and where is the best practice to use If not, can you elaborate Thanks, You can have on failure precedence constraints. These are the red-arrows. They do what they say on the tin, you can respond the failures in the same control flow comntext there an then. And You have event handlers. All containers have event handlers, such as OnError. This in effect gives you another separate Control Flow work area. You can add tasks into the event handler (control flow), and that entire set of control flow will be executed in respon ...Show All

• Dwight Kulkarni Excel "Damage to the file" Error When Exporting With SSRS 2005

  I am getting an error: "Damage to the file was so extensive that repairs were not possible. Excel attemted to recover your formulas and values, but some data may have been lost or corrupted." in some instances when exporting toexcel. The report is no different than any othere report. This report uses rectagles and text boxes to control layout with two tables but it's pretty straight forward. This only happens for this particular report when exported only to Excel. I am using SQL2005 SP1. Any ideas, thoughts, or references are welcome. I can't believe noody answered this yet. I saw the same behavior and the only way we got it to work is to re-publish the data associated with that report AN ...Show All