I'm sure that someone else will understand what is being requested here, but it's beyond me.

Can you please try explaining this again, because I don't understand what the problem is.

Note that @declare table is not valid T-SQL syntax – what do you really mean?

Can you...

While separating the transactions might help, it's not as good a solution as doing it in a single hit. I'll have a look, as, I'm sure, will others.

Something like this?

SELECT *
FROM dbo.Members m
WHERE m.memb_type IN ('Tier 2', 'Tier 3')
      AND NOT EXISTS
(
    SELECT 1
  ...

You should be able to do this update in a single statement.

Without table DDL, sample data as INSERT statements and desired results, it's not easy to provide a working and...

Please provide some sample data (as INSERTs) and desired (post-update) results, based on the sample data.

Here's some sample code not using STRING_AGG() which may be of use:

CREATE TABLE #FileName
(
    FileName VARCHAR(200) NULL
);

INSERT #FileName
(
    FileName
)
VALUES
('file1.txt')
,('file2.txt');

DECLARE @filenames VARCHAR(MAX)...

Avoiding that cursor is pretty easy ... here's some much simpler code for you:

DECLARE @filenames VARCHAR(MAX) = (SELECT STRING_AGG(mf.[Missing Files],', ') FROM Database.Schema.Table mf where mf.[Missing Files]...

• This reply was modified 6 years, 3 months ago by Phil Parkin.

Have you tried adding double quotes around the second param?

"200,210"

Maybe you should finish building the bridge instead of burning it. Not sure if your Report Person is part of IT or the Business. I would have to assume...

I've seen plenty of issues in the past in SSIS when using SQL Authentication.

Are you able to log in with sysadmin rights using Windows authentication & try again?

Are you sysadmin on the instance?

Are you logged in using Windows Auth?

Something like this?

@[User::Path] + "\\" + (@[User::IsActive] == "0" ? "Test1_" : "Test2_") + (DT_WSTR,4)YEAR(GETDATE()) + RIGHT("0" + (DT_WSTR,2)MONTH(GETDATE()), 2) + RIGHT("0" + (DT_WSTR,2)DAY( GETDATE()), 2)+...

Fair enough. You could try comparing package XML before and after setting DontSaveSensitive, using something like WinMerge, to see whether this is a change you can make using find/replace in...

• This reply was modified 6 years, 4 months ago by Phil Parkin. Reason: Fix typo

Using a Conditional Expression. Syntax here.