Thank you both!

I actually run the SSIS package within VS so I can monitor it for any issues so I am watching those black screens pop up.

I added a clustered index on the two fields.  The run time for my SSIS package went UP by about 30 minutes vs having no index on the table.  That...

If the symbol and trade_date form a unique pair in the entire table, make that combination the Clustered Primary Key.  Leave this clustered index on the table at all...

Not quite the same result but has all the info:

SELECT *
  FROM #STOCKS1 AS T1 
  FULL JOIN #STOCKS2 AS T2 
  ...

Maybe?:

SELECT SYMBOL1, SYMBOL2
FROM (
    SELECT SYMBOL1, ROW_NUMBER() OVER(ORDER BY SYMBOL1) AS row_num_1
    FROM #STOCKS1 S1
    WHERE NOT...

I made a bit of progress.  The format doesn't quite match the desired outcome.  What can I do to fix it so it does match the desired outcome?

            
November 14, 2024 at 5:57 am
            
#4481479

            
            
                                                
        

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 10 months 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 10 months 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...