Not sure if that is exactly what you are looking for ...

Yes, that worked for me. It is a little slow, but I'm not dealing with large datasets, so it's...

This is unworkable. Surely it is clear that a fixed-width file cannot have headings which are wider than the length of their column?

Try switching the order of CTE and tableB in your LEFT JOIN. Or leave as is and change to a RIGHT JOIN.

Fair enough. I'd be tempted to take it offline early one morning and then keep an ear open for the Help Desk calls ... Maybe that's why I'd make a...

Thanks to you both for your efforts.

I now have this working via an Execute Process task (though I still have to do some serious parameterisation to make it production-ready).

So I'm...

Thanks, Thom. I actually tried that already. It seems that this module works with .NET Core only.

Can you check if anyone is using the database based on the logs? Want to check if anyone is accessing the db. If yes, with logs how is that possible?...

I don't think 'interim table' is the correct term here...

Like this?

DROP TABLE IF EXISTS #X_ReadytoPick;

CREATE TABLE #X_ReadytoPick
(
    SOPstatus VARCHAR(50)
   ,OpsStatus VARCHAR(50)
   ,OrderNumber VARCHAR(50)
);

INSERT #X_ReadytoPick
VALUES
('Acknowledgement', 'Okay', 'ORD001')
,('Pack Complete', 'Picked', 'ORD002')
,('Pack...

Thanks Phil, I appreciate your advice but this data is to be loaded into an CRM system that will only accept dates in this format.

I've since thought that I...

Thanks frederico_fons,

I get what your saying as I've noticed that any transform I've been doing changes the data type to String. So I thought the best idea was to...

Use an ExecuteSQL task and do it in T-SQL using REPLACE with the standard trick. For example, for commas:

SELECT REPLACE(
       ...

The client does have this odd requirement to use package, not project deployment.

You did say this in your initial post. Thom's question, however, was 'why is this restriction in place?'

We're...

Straightforward and works perfectly, thanks very much...

Is the SQL DB destination table the same for both packages?

Is the lock being applied on that table, or on other objects?