Hello @roblu001,
SSIS is data integration tool while KNIME, although extensively used for ETL, is a data science tool.
Check this topic (and links in it) for more:
Besides what is mentioned in above topic(s) there are two important things to note:
- KNIME Database extension received a lot of improvements lately. First it was rewritten and from then continuously improved with new functionality. It’s not impossible to see more “data integration” features within KNIME in future
- With KNIME Analytics Platform, as opposed to SSIS, there is no built-in scheduling option. For more on KNIME workflow scheduling and automation see here
Welcome to KNIME Community and hope this helps!
Br,
Ivan