Instead of logging your errors in a physical table (whose changes are being rolled back, I assume), log them in a table variable and then insert from the table variable...

Which part of an SSIS project deployment do you think cannot be achieved through DevOps?

I swapped things around a bit. Obviously, I cannot test it.

ALTER PROCEDURE dbo.RunStoredProcedures
AS
SET NOCOUNT ON;

DECLARE @FAIL_COUNT INT = 0;

BEGIN TRANSACTION;

BEGIN TRY
    BEGIN TRY
 ...

I have never created a custom task in SSIS, so I'm not going to be able to help you with this, unless you have specific questions about C# code within...

Try running the problem proc first (in a SEQ container) before all of the others.

• This reply was modified 8 months ago by Phil Parkin.

-- Reply deleted

• This reply was modified 8 months ago by Phil Parkin.

Are you planning on using Events in a Script Task to do this?

https://learn.microsoft.com/en-us/sql/integration-services/extending-packages-scripting/task/raising-events-in-the-script-task?view=sql-server-ver16

This is a good round-up of what is possible with JSON and SQL Server. Well done on putting it together.

My one non-JSON comment would be regarding the following:

Always implement proper...

My translation software came up with the following:

Hello

Do you know if the use of begin try and catch can cause database crashes when executing stored procedures with high volume of...

That's interesting. I assume you've done this multiple times, with the same (approximate) result?

While I'm sure that people appreciate the effort behind this blog post, this is not really the place for it. If you want to submit technical articles like this, I...

Hi Martin,

please see this - https://www.sqlservercentral.com/forums/topic/how-create-a-google-bigquery-connection-manager-in-ssis

I am trying to use a google bigquery connection. However It seems not so straight forward as I cant seem to find the connection...

• This reply was modified 8 months, 2 weeks ago by Phil Parkin.

with that I totally disagree - server should have 64 bit version - and workstation should have the one matching the VS version you have (32 bit if lower...

Yes, despite some rather "hacky" solutions, you can't have the x86 and x64 Redistributables installed on the same system.  Ideally, you have the one that matches what's on the...

The app is just display engine... I use the PS to export from mssql and load to PG...

This piece of code is the issue.

# Convert the image data to...