SSIS Data Flow Components

“Liked that it connects many sources and destinations and performs well with large data. Found it can be buggy and that pipelines become hard to maintain over time.”

“Liked connecting to MySQL behind an SSH server and the ease of use once configured. Found the setup documentation unclear and needed support to get running.”

“Liked the fast setup, good value, many tuning settings, and drag-and-drop design. Found gaps in the documentation for individual components.”

“Liked the very fast data transfer and the easy Execute SQL task. Found that a Send Mail task failed after SMTP changes and support was hard to reach.”

“Liked that the components were easy to implement in existing work and relatively inexpensive compared with other options. Noted no major drawbacks.”

“Liked how well it connected Tableau to SQLite, first for a proof of concept and then for a year of production use. Noted no major drawbacks.”

“Liked how easy it made Salesforce integration. Found that the lack of a caching option means development requires a live Salesforce connection.”

“Liked the easy installation process and simple first-time setup of the components. Found the initial download of the software slow to complete.”