Or create a linked server on the TBL_A server to the server with the codes table. Then create a view on the TBL_A server which returns the required data (join...

Execute Process.

Set a breakpoint in your code by clicking on one of the lines near the top and hitting F9. A red dot will appear in the margin.

Save that and click...

But you have SSIS installed? Otherwise, how are you running this?

Have you stepped through the code in debug? This should help you identify the exact cause of the problem.

Expand on what you mean by this please. What have you tried?

I do that sometimes ... it's not always a happy experience - sometimes you realise...

Well that clears things up.

Personally, I'd keep the file name as-is and instead use...

😎

Thanks for...

Try this. Use a Script task and add the following two Usings:

using System.Net;

using System.IO;

Then change your Main sub - here's something I copied from elsewhere on the Web:

...

Or this

with x as (select CustomerNumber = '0001',

...

We don't like cursors much here 🙂 Can you tell us what you are trying to achieve & we'll almost certainly find a faster way to do it.

Nice, thanks Andy.

Aha, I should have thought about that.

Well done on figuring it out.