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 1 month, 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 2 months, 2 weeks ago by  water490.

deleted post

• This reply was modified 2 months, 2 weeks 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)...

deleted post

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

First of all, the warning was telling you that you have columns that you're doing aggregates like SUM() and COUNT() on contain some NULL values.  Are you...

deleted post

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

google is your friend - you should have done it first.

https://learn.microsoft.com/en-us/sql/t-sql/statements/set-ansi-warnings-transact-sql?view=sql-server-ver16

regarding the code and because you got a timeout  I would add a command timeout before the...

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