Show me how to make this better, if you don't  mind. String split isn't recognised for some reason, which makes no sense, unless my version of ssms is too old.

Whether...

What have you actually installed? How is Visio relevant to any of this?

This link shows you how to use SMO to generate the CREATE TABLE script.

Update U set col10=col10+@SSISvariable From mytable U where U.col1='xyz' and col2='abc'

This will update col10 in the same set of rows for each iteration of the loop. Why would you do...

Seems that a good architecture for you would be to push the imported data into (truncated) staging tables and then execute one or more procs which MERGE the staged data...

then on success to a sql task with a waitfor delay

Or a script task with a Thread.Sleep().

Edit: changed my mind.

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

As long as you don't mind which order the 'UniqueNumber' is assigned in, this might work:

WITH counts
AS (SELECT p.PartNumber
        ...

I've modified your structure a little to make it more relational and injected some constraints to demonstrate typical referential integrity. Hopefully, it helps you with this. Post back with any...

Or run the queries direct from Excel using PowerQuery.

Nothing else comes to mind. It feels like it's something outside of SSIS ... could some other process be locking the file temporarily? A/V software or some sort of folder...

Then it's a puzzle. You could try setting DelayValidation = True on the CM.

You could also check the All Executions report to look for any other clues. Does the error...

Sorry, I missed that.

Does your script task use the connection manager? Are you disposing it?

That's a very common error, so don't expect it to correlate well to whatever the problem is!

Are you trying to read anything in parallel, eg, two or more sheets in...

• This reply was modified 3 years, 5 months ago by Phil Parkin. Reason: Fix typo

In SSMS, that is not possible – it is seen as a query tool, not a presentation tool.