I received the following information about this issue from the author of SSMS Tools (Mladen):

It is an issue with extensions because they internally upgraded the assemblies.

They moved to newer sqlclient...

Lucky you! Out of interest, do you have any SSMS extensions installed (SQL Prompt, SQL Search and the like)? I...

So you solved it? OK.

If it were me, I would be searching across my .DTSX for the text 'FileA' – it must be coming from somewhere!

As you are using a FOREACH container to iterate across a folder, why are you also defining file names? Why not simply let the container pick up *.xlsx within the...

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

Try putting 'GO' after each statement.

ALTER ...
GO
DELETE...
GO

In my experience, ERDs are common during the initial database design phase, but rarely maintained as changes are made.

When you run the script task, you should be able to step through the code, line by line (you only need one breakpoint at the start to make this process...

Run the script in debug mode to determine the line which causes the error and to dig deeper into the details of the error.

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

So ... you're using PGP and the executable is called GPG ... weird, but OK!

If that is just the encryption process, what is doing the SFTP part which is when...

How will the data be used, other than for INSERTs?

What does gpg.exe do?

Perhaps the word 'DevOps' has confused things here? I'm assuming you're talking about 'Azure DevOps' specifically, and not DevOps is general?

Azure DevOps can be used for several things, including task...

Thank you for the response, Steve.

I have tracked down the problem – for testing purposes, a database restore had been performed, from a database with CT enabled. Nothing was consuming...

Hi Steve, sorry for the slow reply.

One of the database sources is SQL Server 2022, CU22, with DB at compatibility level 100.

Another is an Azure SQL database which is running...

Sure there is. In your Excel source, define a suitable sheet name and range, eg

Sheet1$A1:H21