We often receive questions about when to use SSIS with our REST API task or the other tasks related to REST API (SSIS JSON Source, SSIS JSON Destination, JSON Generator transform, etc) and when to use CURL.
Both are used for REST API calls, but they are extremely different.
SSIS Zappysys tasks are recommended for people who are familiar with SSIS or they need to automate and integrate data from different sources. If you need to load REST API information for reports and you want to automate all the load process, the ZappySys tools are the answer to your prayers.
By the other hand, curl is recommended for people who love the command line and do not have experience or licenses for SSIS. curl will save some money because it is completely free.
If you feel comfortable with the UI, workflows, the SSIS is the solution.
If you love the command line, batch files, curl is your path. Of course, you can combine and call the command line in SSIS. If you love both options you can use the process task to invoke the command line in SSIS as well.
Migrate CURL Command Line Settings to ZappySys SSIS PowerPack / ODBC
Contact Us
If you have more question(s) feel free to contact us via Live chat or email to support@zappysys.com
Comments
0 comments
Please sign in to leave a comment.