148 How to do incremental load to mysql from sql server using ssis

How to do incremental load to mysql from sql server
Download the file\script used in the Video from below link

How to do incremental load to mysql from sql server
How to get incremental data in MySQL?
how to do incremental load in mysql

[tapankamble]

Can you please help to understand how to handle NULL values in conditional split as i don't want my staging table to get those incorrect row count of null values

[teddyfabriciocordovasaenz]

Incredible Sir!
A question, I have a complex package and I need to execute the next task only is the previous one (script SQL task) in fully completed and success, is this possible?

[lzfhkve]

How to dynamically move multiple incremental record (insert update delete) sql tables from one server to another using SSIS?

[namgaywangchuk]

is there any way I can delete the data from destination database table when the data in the source table is deleted particularly using merge join and conditionalsplit? Source: mysql, destination: sql server

[remek]

Is there any particular reason that update query is part of execute sql task and not part of data flow? I assume that you could have a condition to add data to email table on updated rows with conditional split or am I missing something?

[nagendrababu]

Can we update an oracle table from ssis? I tried with execute sql task but it will not work.

[danishhussain]

So, I have 1 millions rows in mysql
I want to replicate it to mssql in every 10 seconds..

what method should I take ?
If I go with this tutorial, it will update 1 millions rows every 10th seconds which will be a disaster..
what am I supposed to do here? please help

[egwpuqc]

ok your channel is superb but now you do a complete etl such as removing column and removing those row which contain nulldata and add one or two column from another table and inserted only updated record and inserted only new records and do aggregation such as i have sale in province wise so save data in new column with name of pronince and just save data in warehouse is only valueable data which is almost ready for making dashboard for analysis
i want to say you do some extraordinary work / full professionally work which is helpful in
big organization

[hienleinh]

how to delete incremental load record to mysql from sql server using ssis

[markippo]

Honestly I don't see any incremental approach here - you needed to download all the data from sql server table, all the data from MySQL table... Then costly sort them, join them, split them doing logical operation. I'd call it - heavy and intensive operations out of sql server memory pool, without sql engine capabilities to perform fast and efficient operations on data sets... On larger datasets this approach will be slower than - truncate destination and fetch all data once again. Incremental means - fetch only those data that should be fetched - then do the rest - update, insert and very often omitted - delete. Your table dosen't have any obvious marker that data have changed. My approach:
1) on source - make additional table with id and binarysumcheck column (make it empty before first run)
In ssis:
2) left join with that table - taking only rows with different sum (updated) or not existing (insert) .
3) split them and do the rest
4) recalculate additional table

If you don't have a luxury of modification the source... You are... To be honest doomed...

[b.n.v.sunilkumar]

Why can't we use look up Or SCD? Because of mysql won't support this type of operations or any other reason