No problem.

Just picking up on one point in your last comment, I 100% agree with using stored procs to implement business logic on the SQL Server side. I mostly use...

Thank you for the screenshots, that helps explain what is going on. But I don't think I can help. I do not understand why it is complaining about SQL syntax...

There are reasons for separating logic into multiple packages, even though it may seem less tidy and requires more config up front.

Number 1 is around error handling and the debugging...

SSIS is not the best place for DDL – it's best to do your table creates before going near SSIS.

Were you able to successfully create a Connection Manager in SSIS?...

You have created a table in MariaDb and you are using an ExecuteSQL task containing

INSERT INTO SampleTable VALUES
    ('2023-05-31', 1.5, 2.3, 3.1, 4.2, 100,...

Can you post the SQL which is causing the error?

If you can purchase third-party software products, the following may be of interest:

https://www.cozyroc.com/ssis/data-flow-task

But, as stated above, the structure of SSIS packages is fixed at design time. If you create separate...

If it's not compressed, you could try zipping it first. But one way or another, the data has to get from A to B. Is there a reason why you...

Restore from a backup file instead.

Nice tweak, that's much cleaner. Thanks, Jonathan.

Maybe this?

DROP TABLE IF EXISTS #Data;

CREATE TABLE #Data
(
    CLNUM INT
   ,Model INT
   ,CLSTATUS CHAR(1)
   ,CLSTATDATE DATE
  ...

By this I mean it is out of order which it should be

Please take some time to think about people reading your post. We have no idea ... none at...

Here is a formatted version. Note that all of your

CAST ('YYYY-MM-DD' AS DATETIME)

statements can be simplified to 'YYYYMMDD'. As suggested above, this looks like homework to me.

CREATE...

You did exactly the right thing in adding the []. Your other fix also looks good, well done on resolving the issues!

Knowing when to use Python in SQL Server depends on the specific requirements and tasks you need to accomplish. Python can be used in various scenarios within SQL Server,...