I am selecting from SQL server, and writing into Oracle. The performance is about 100 to 200 rows per sec. I have tried Oracle OLE db, and MSDAORA both. The...

thanks everyone 🙂

I had posted the question in 2006, and have got three replies in the last two days!! Appreciate your help.

when you say "package" are you referring to SSIS or is there some other package in SQL server?

thanks!

The source is an Oracle database. My query is:

Insert into SQL_Table

( columns)

Select columns from openquery (Linked_server, 'Query_Oracle')

I ran multiple queries without any partitioning - I ran into deadlocks. I...

I tried the procedure sp_addextendedproperty and it does what I need. Thanks Jeff, Matt, RBarry, Noel, and Gsquared.

That SQL was helpful and gave me what i was looking for. Thanks to those who put it here. Another question:

I have column comments as Extended Properties in one database...

Yeah, exactly what i had in mind. But i need to wait until the weekend to do that.

Thanks Mark,

You solution also looks good, will try it out. Thanks

Sure Jeff...The recursive parsing function followed by the function to count and summarise the entire table based on input dates.

CREATE FUNCTION dbo.MPM_PARSE_ERROR(@error_number VARCHAR(100))

RETURNS @ERROR_TABLE TABLE (ERROR VARCHAR(5))

AS

BEGIN

/*------------------------------------------------------------

Name   : MPM_PARSE_ERROR

Input  :...

Thanks Jeff, Serqiy. I really appreciate the detailed reply that Jeff gave. Also, I realise that delimited data is good in files, not in database tables. I have learnt it...

This is excellent!!

I had attempted using that option but could never figure out how it should be used. This will really help me. Thanks!

How is the table being used? By what application?

If you are generating a report from that table, you do not want the report to spend crucial minutes in making joins...

As i understand your problem, you execute the Stored proc, tables are updated, the results have to be seen on a website browser.

If you do not want to refresh the...

I have faced the same problem in DDQ a couple of times. The column names and parameters get mismatched on their own. DTS is haunted

Thanks Mike,

Does that mean I can not "turn off" scientific notation at the server level? And please let me know what exactly you mean by "regular expression match". The input...