It works.  Thank you so...

1. I hope you are not using floats for prices! 2. Do you really use reserved names for columns? 3. Are you really writing new code with the depreciated...

Hi

Is anyone able to help me with this?

Thank you

Thank you for the prompt reply.

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 1 month, 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...