Good question. I stopped worrying about it after finding out the issue was due to a DNS 'reconfiguration'...

Yes there is. But perhaps the desire is to remove direct database connections.

Versions of VS before 2022 were 32-bit, but 2022 onwards is 64-bit.

Not true. I debugged a Script Task in VS2022 the other day. Breakpoints in a Script Component were ignored, however.

1. Then try the script component source method
2. I have no idea why the FOREACH container would run more than once, assuming your screenshot is representative of the entire package.

Can...

1. Maybe not. But there are likely options, such as (a) Using a Script Component source & writing some C# to decipher the XML and output the columns, or (b)...

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 weeks, 1 days 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 1 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...