I figured out the problem.  I just don't know the best way to fix it.

The problem is that some files have an apostrophe in the name:

Information: 0x0...

I tried using C# to load them.  Still getting errors (but different this time).

Errors:

SSIS package "C:\Users\Me\Documents\Trading\SSIS\Analysis Toolkit SSIS v4\Analysis Toolkit SSIS\Package.dtsx" starting.
Information: 0x0 at Update Table Stocks...

• This reply was modified 11 months, 2 weeks ago by water490.

I made a mistake.  There was so much output that I missed other errors.  Here is the revised list:

Error: 0xC0202009 at Update Table Stocks, Update Stocks Table...

Sorry for the confusion.  The post you are referring to isn't related to your...

I thought that maybe because I am not outputting NAME into the final table that may be the issue.  It didn't change anything.

Error: 0xC02020A1 at Update Table...

• This reply was modified 11 months, 2 weeks ago by water490.

If you look at the column headers of the file and compare them to the table, they don't match.  We can't see your package to know what the...

OK, those errors are actually pretty helpful.

There must be one or more occurrences of the column NAME in file

ADAP.O#Adaptimmune Therapeutics ADR Representing 6 Ord Shs (D).csv

where the data is...

Have you looked at what's going on in SQL server when the procedures get stuck? If you use something like sp_whoisactive it's easy to see if you have spids...

I think the issue is different so I am going to start a new thread

Here you are courtesy of ChatGPT:

Yes, it’s possible to run specific stored procedures (SP1 and SP2) in parallel and then have SP3 and SP4 execute in series within a...

I have two versions of SSIS setup to test the benefits of parallelism.

Version 1 - no parallelism setup.  The precedence constraint I am using between the Execute SQL Tasks is...

thank you everyone for your feedback.  i will implement as noted.

deleted post

• This reply was modified 1 year ago by water490.

deleted post

• This reply was modified 1 year ago by water490.

Yes - you definitely need to be using precedence constraints between tasks.

1. Reads (select) don't block other reads - locks on a select could prevent inserts/updates/deletes on the table(s)...