Assuming you have your SSIS solution checked in to Git, the DevOps deployment is a two stage process.

1. A build pipeline builds the solution and publishes the build artifacts (ie,...

Nasty! OK, here is another thought. How about pre-processing the file and replacing every occurrence of

n"

(where 0 <= n <= 9)

with n~

Then importing the data, then replacing ~ with "...

Some good input here, but I've run into an issue, that I can't get the team exporting the data to fix.

I'm getting data like this: PartNo,Description,Cost

1234,"Pipe 2"x6" galvanized",1.45

5678,"Frame, Wood,...

I said 'add another THROW', not 'add another THROW 51000, '2. One or more stored procedures had errors, please investigate', 1;'!

Also, surely you want the INSERT to dbo.RunTimeErrors to occur...

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

Did you add another THROW in the final CATCH block, like I suggested?

If yes, please post the code.

No, only 1 TV is required. You simply run multiple INSERTS to it in your code.

To make the error appear in the SSIS Output window, you need to add THROW...

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 1 years, 8 months ago by Phil Parkin.

-- Reply deleted

• This reply was modified 1 years, 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...