I am not sure...

• This reply was modified 17 hours, 44 minutes ago by  water490.

Instead of moving processed files to a single archive folder, create a timestamped folder in the target folder and move the file there.

You will never get collisions if you...

issue fixed.  Adding IS_MS_SHIPPED = 0 removes the SP in question.

I have made some progress on this.  I had to change the FROM table and now I can see the creation and last modified dates.  However, the query is showing...

Does encrypting the DB cause performance issues (ie run time increases) for queries?

WITH ordered
AS (SELECT UNIT
          ,ORDER_DATE
          ,rn1 = ROW_NUMBER...

You could change the approach to use a script task to execute your powershell script.  However, if you can do this in PS - then you almost certainly can...

How are you specifying to run PowerShell, as a scripting task? Spitballing here, but could you run it as an Execute Process Task, with powershell.exe as the executable? Then...

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...

Yes I did.  If I add the second THROW then the table...

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...

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...

• This reply was modified 1 month, 3 weeks ago by  water490.

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 made some progress on this.

Code:

ALTER procedure [dbo].[RunStoredProcedures]
as

DECLARE @FAIL_COUNT INT = 0

BEGIN TRANSACTION

BEGIN TRY
BEGIN TRY
  truncate table dbo.temptable
END TRY
BEGIN CATCH
SET @FAIL_COUNT = @FAIL_COUNT + 1
END CATCH

BEGIN...

I have been thinking more about this.  I don't think relying on SSIS output window is the right way to capture errors.  I need a persistent record of errors (not...

• This reply was modified 1 month, 3 weeks ago by  water490.
• This reply was modified 1 month, 3 weeks ago by  water490.
• This reply was modified 1 month, 3 weeks ago by  water490.
• This reply was modified 1 month, 3 weeks ago by  water490.