Have you tested this script for performance with, say, one million rows in the Excel sheet? It would be interesting to know how it performs when compared with doing the...

You're...

What you have provided are the properties for a Script task. There is no hint of any data being 'read'. Do you really think that anyone will be able to...

Try changing your WHERE clause to this:

WHERE CAST(DocumentXML AS NVARCHAR(MAX)) LIKE '<Document>%'

As these 'errors' are not considered significant enough to halt execution, I'd suggest logging them as they happen to an ErrorLog table and picking up / reporting any entries created...

Thank you!

Can you give an example of the sort of failures you are referring to? I'm assuming nothing terminal (network failure, hardware failure etc).

By default, stored procedure failures would (as far as I remember) fail the package from which they are executed. I assume you've configured things so that this does not happen?...

Can you please confirm this statement:

1 record has match is 2 because it has in 2 subsequent previous month data was there with mainhost

You are referring to the 2023-12-31 row,...

Then perhaps you will find this informative: https://aws.amazon.com/compare/the-difference-between-sql-and-mysql/

You've been here long enough to know the forum etiquette: please re-post your original question and its solution. This may come in useful to others.

First, please note that this is a SQL Server forum, not MySQL.

In T-SQL, I'd do something like this

DROP TABLE IF EXISTS #wp_um_metadata;

CREATE TABLE #wp_um_metadata
(
   ...

--Removed duplicate

• This reply was modified 1 year, 10 months ago by Phil Parkin.

No. As demonstrated below.

DROP TABLE IF EXISTS #x;

CREATE...

This will be easier to answer if you provide the DDL for the underlying table, including PK and Index definitions. If the query really is as simple as you suggest,...

Possibly because the prod environment...