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, 9 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, 9 months ago by Phil Parkin. Reason: Fix typo

Using a Conditional Expression. Syntax here.

I take it that keeping your packages in their corresponding source control branches is not possible?

Expedia and other travel sites are being battered at the moment by people stranded as a result of Thomas Cook going into administration ... that may be a factor.

DECLARE @x VARCHAR(4000)
    = '<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

<soap:Body>

<ns1:openSResp xmlns:pf1="http://autogd.NewWebServiceApi.webnew.com/">

<return xmlns:pf2="http://autogd.NewWebServiceApi.webnew.com/">

<pointid>0</pointid>

<newstatus>failed</newstatus>

<ssId>Seasond12453678</ssId>

</return>

</pf1:openSResp></soap:Body>

</soap:Envelope>';

SELECT SUBSTRING(@x, CHARINDEX('<ssid>', @x) + 6, CHARINDEX('</ssid>', @x) - CHARINDEX('<ssid>', @x) - 6);

That's fine, but...