1. [Home](https://www.g2.com/) 2. ... 3. [On-Premise Data Integration Software](https://www.g2.com/categories/on-premise-data-integration) 4. [COZYROC Solutions Discussions](https://www.g2.com/products/cozyroc-solutions/discuss) [ ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/large_detail/large_detail_6fc3a0b714b22147ef6e5985f01d7557/cozyroc-solutions.png "Product Avatar Image") ](/products/cozyroc-solutions/reviews) [ COZYROC Solutions ](/products/cozyroc-solutions/reviews) (34)4.8/5 COZYROC Solutions offers world-class On-Premises ETL and Cloud integration solutions with COZYROC.Cloud (iPaaS) COZYROC SSIS+ is a comprehensive suite of 270+ advanced components for developing ETL solutions with Microsoft SQL Server Integration Services. Our easy-to-use, coding-free library of tasks, components and reusable scripts can significantly cut your development time and also improve the execution speed of your SSIS packages. Support for SQL Server 2012-2022 \* Major highlights of the 2.2 release \* ​Derived Column transformation component, a powerful replacement of the standard Derived Column transformation with support for expressions in JavaScript. https://cozyroc.com/ssis/derived-column \* ​Database Source component for loading data from a database table, a view or a SQL command. The component can be configured for ADO.NET, OLE DB and ODBC connection managers. https://cozyroc.com/ssis/database-source \* ​ASN.1 Source component for retrieving data from ASN.1 file /BER, CER or DER encoded/ that supports multiple outputs via the composite records pattern. https://cozyroc.com/ssis/asn1-source ​Tableau Source, for consuming data from a Tableau .hyper file (i.e. the latest evolution of Tableau Data Extract). https://cozyroc.com/ssis/tableau-source \* The new version includes support for 37 additional applications https://cozyroc.com/blog/cozyroc-ssis-22-now-officially-released \* Major highlights of the 2.1 release \* XML Destination component: https://www.cozyroc.com/ssis/xml-destination \* OFTP connection manager - https://www.cozyroc.com/ssis/oftp-connection \* Database Destination component for fast loading and updating data. Insert, Update, Delete or Upsert in row-by-row or bulk-load mode for ADO.NET, OLE DB and ODBC. https://www.cozyroc.com/ssis/database-destination \* JSON Source component for retrieving data from JSON documents that supports multiple outputs via the composite records pattern. https://www.cozyroc.com/ssis/json-source \* JSON Destination component for generating JSON documents that supports multiple inputs via the composite records pattern. https://www.cozyroc.com/ssis/json-destination \* Easier connectivity to any REST service. \* Support of Dynamic data flows and composite records modelling \* Fast Sort Plus component for sorting of LARGE amounts of data. \* EDI components \* Additional REST services connectivity https://www.cozyroc.com/ssis/rest-connection COZYROC Solutions has been successfully used by thousands of businesses, in more than 142 countries around the world. \*\*\*\*\*\*\*\*\*\* COZYROC Cloud - The Simplest Way to SSIS in the Cloud: https://cozyroc.cloud COZYROC Cloud delivers seamless hybrid integrations, effortlessly connecting cloud and on-premises applications and databases, supporting cloud repatriation. \* Hosted and hybrid cloud integration solutions \* Managed & On-Premises Execution Environments \* Webhook Triggers -Automatically run packages by subscribing to external events (via inbound webhooks). \* Centralized Management \* Superior support for consuming web APIs \* Advanced ETL components: Database Destination, Table Difference, Lookup+ \* Free during development & testing. Pay only for production use \* Avoid cloud lock-in. Be able to transfer ETL processes on premises \* Better extensibility. Multiple component vendors. \* Lightweight JS-based components Show More * * * ### 93.0 Nps Score Already have COZYROC Solutions? ### All COZYROC Solutions Discussions Search Most CommentedMost HelpfulCommon QuestionsNewest All DiscussionsDiscussions with CommentsCommon QuestionsDiscussions without Comments FilterFilter Filter byExpand/Collapse Sort by Most Commented Most Helpful Common Questions Newest Filter by All Discussions Discussions with Comments Common Questions Discussions without Comments ![Pinned by G2 as a common question](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Pinned by G2 as a common question") G2 Pinned by G2 as a common question • about 3 years ago More Options - [ # What is COZYROC SSIS+ Library used for? ](/discussions/what-is-cozyroc-ssis-library-used-for) What is COZYROC SSIS+ Library used for? [ On-Premise Data Integration Software ](https://www.g2.com/tags/on-premise-data-integration-software)[ iPaaS Software ](https://www.g2.com/tags/ipaas-software)[ ETL Tools ](https://www.g2.com/tags/etl-tools) * * * (true)\<0\>0\>Upvotes (false) * * * 1 Comment [![linkedin](/assets/social-logos/linkedin-afe65e46604a5bd5105ab9c856116204040b6b3f2b2d42562fc8071ca0c48ca0.svg "linkedin")](https://www.linkedin.com/shareArticle?mini=true&summary=Ask+COZYROC+Solutions+questions+and+get+answers+from+expert+users+in+our+COZYROC+Solutions+Discussions+section.&title=COZYROC+Solutions+Discussions+%7C+G2&url=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss) [![twitter](/assets/social-logos/twitter-61aaec80434c71387b8f7326e480592eae71c0a65afd051d66fce9b75a9bf417.svg "twitter")](https://twitter.com/intent/tweet?text=COZYROC+Solutions+Discussions+%7C+G2&url=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss&via=G2dotcom) [![facebook](/assets/social-logos/facebook-350d0b410d6b10debcf893050e803a8633d53561aa42807b087b8daf9be3668f.svg "facebook")](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss) [![gmail](/assets/social-logos/gmail-6db42f21e7c254fae201b112bef0dd15d25223a5cbb32691ce80eab43761eadf.svg "gmail")](https://mail.google.com/mail/?view=cm&fs=1&tf=1&to=&su=COZYROC+Solutions+Discussions+%7C+G2&body=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss%0aAsk+COZYROC+Solutions+questions+and+get+answers+from+expert+users+in+our+COZYROC+Solutions+Discussions+section.) [![mail](/assets/social-logos/mail-d55c53b04bf49872e40cd2443b85a99caa23394e6cf154ae32a9d08377c15d86.svg "mail")](mailto:?subject=COZYROC+Solutions+Discussions+%7C+G2&body=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss%0aAsk+COZYROC+Solutions+questions+and+get+answers+from+expert+users+in+our+COZYROC+Solutions+Discussions+section.) ![copy_link](/assets/social-logos/copy_link-05d8dc5dc8576fc78425ad34d07241b060878835e555a30417ff41c18335e575.svg "copy\_link") ![Pinned by G2 as a common question](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Pinned by G2 as a common question") G2 Pinned by G2 as a common question • about 4 years ago More Options - [ # Is SSIS part of SQL Server? ](/discussions/is-ssis-part-of-sql-server) Is SSIS part of SQL Server? [ On-Premise Data Integration Software ](https://www.g2.com/tags/on-premise-data-integration-software) * * * (true)\<0\>0\>Upvotes (false) * * * 0 Comments [![linkedin](/assets/social-logos/linkedin-afe65e46604a5bd5105ab9c856116204040b6b3f2b2d42562fc8071ca0c48ca0.svg "linkedin")](https://www.linkedin.com/shareArticle?mini=true&summary=Ask+COZYROC+Solutions+questions+and+get+answers+from+expert+users+in+our+COZYROC+Solutions+Discussions+section.&title=COZYROC+Solutions+Discussions+%7C+G2&url=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss) [![twitter](/assets/social-logos/twitter-61aaec80434c71387b8f7326e480592eae71c0a65afd051d66fce9b75a9bf417.svg "twitter")](https://twitter.com/intent/tweet?text=COZYROC+Solutions+Discussions+%7C+G2&url=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss&via=G2dotcom) [![facebook](/assets/social-logos/facebook-350d0b410d6b10debcf893050e803a8633d53561aa42807b087b8daf9be3668f.svg "facebook")](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss) [![gmail](/assets/social-logos/gmail-6db42f21e7c254fae201b112bef0dd15d25223a5cbb32691ce80eab43761eadf.svg "gmail")](https://mail.google.com/mail/?view=cm&fs=1&tf=1&to=&su=COZYROC+Solutions+Discussions+%7C+G2&body=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss%0aAsk+COZYROC+Solutions+questions+and+get+answers+from+expert+users+in+our+COZYROC+Solutions+Discussions+section.) [![mail](/assets/social-logos/mail-d55c53b04bf49872e40cd2443b85a99caa23394e6cf154ae32a9d08377c15d86.svg "mail")](mailto:?subject=COZYROC+Solutions+Discussions+%7C+G2&body=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss%0aAsk+COZYROC+Solutions+questions+and+get+answers+from+expert+users+in+our+COZYROC+Solutions+Discussions+section.) ![copy_link](/assets/social-logos/copy_link-05d8dc5dc8576fc78425ad34d07241b060878835e555a30417ff41c18335e575.svg "copy\_link") ![Pinned by G2 as a common question](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Pinned by G2 as a common question") G2 Pinned by G2 as a common question • over 4 years ago More Options - [ # What is cozy rock? ](/discussions/what-is-cozy-rock) What is cozy rock? [ On-Premise Data Integration Software ](https://www.g2.com/tags/on-premise-data-integration-software) * * * (true)\<0\>0\>Upvotes (false) * * * 0 Comments [![linkedin](/assets/social-logos/linkedin-afe65e46604a5bd5105ab9c856116204040b6b3f2b2d42562fc8071ca0c48ca0.svg "linkedin")](https://www.linkedin.com/shareArticle?mini=true&summary=Ask+COZYROC+Solutions+questions+and+get+answers+from+expert+users+in+our+COZYROC+Solutions+Discussions+section.&title=COZYROC+Solutions+Discussions+%7C+G2&url=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss) [![twitter](/assets/social-logos/twitter-61aaec80434c71387b8f7326e480592eae71c0a65afd051d66fce9b75a9bf417.svg "twitter")](https://twitter.com/intent/tweet?text=COZYROC+Solutions+Discussions+%7C+G2&url=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss&via=G2dotcom) [![facebook](/assets/social-logos/facebook-350d0b410d6b10debcf893050e803a8633d53561aa42807b087b8daf9be3668f.svg "facebook")](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss) [![gmail](/assets/social-logos/gmail-6db42f21e7c254fae201b112bef0dd15d25223a5cbb32691ce80eab43761eadf.svg "gmail")](https://mail.google.com/mail/?view=cm&fs=1&tf=1&to=&su=COZYROC+Solutions+Discussions+%7C+G2&body=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss%0aAsk+COZYROC+Solutions+questions+and+get+answers+from+expert+users+in+our+COZYROC+Solutions+Discussions+section.) [![mail](/assets/social-logos/mail-d55c53b04bf49872e40cd2443b85a99caa23394e6cf154ae32a9d08377c15d86.svg "mail")](mailto:?subject=COZYROC+Solutions+Discussions+%7C+G2&body=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss%0aAsk+COZYROC+Solutions+questions+and+get+answers+from+expert+users+in+our+COZYROC+Solutions+Discussions+section.) ![copy_link](/assets/social-logos/copy_link-05d8dc5dc8576fc78425ad34d07241b060878835e555a30417ff41c18335e575.svg "copy\_link") ![Pinned by G2 as a common question](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Pinned by G2 as a common question") G2 Pinned by G2 as a common question • over 4 years ago More Options - [ # What is Cozyroc used for? ](/discussions/what-is-cozyroc-used-for) What is Cozyroc used for? [ On-Premise Data Integration Software ](https://www.g2.com/tags/on-premise-data-integration-software) * * * (true)\<0\>0\>Upvotes (false) * * * 1 Comment [![linkedin](/assets/social-logos/linkedin-afe65e46604a5bd5105ab9c856116204040b6b3f2b2d42562fc8071ca0c48ca0.svg "linkedin")](https://www.linkedin.com/shareArticle?mini=true&summary=Ask+COZYROC+Solutions+questions+and+get+answers+from+expert+users+in+our+COZYROC+Solutions+Discussions+section.&title=COZYROC+Solutions+Discussions+%7C+G2&url=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss) [![twitter](/assets/social-logos/twitter-61aaec80434c71387b8f7326e480592eae71c0a65afd051d66fce9b75a9bf417.svg "twitter")](https://twitter.com/intent/tweet?text=COZYROC+Solutions+Discussions+%7C+G2&url=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss&via=G2dotcom) [![facebook](/assets/social-logos/facebook-350d0b410d6b10debcf893050e803a8633d53561aa42807b087b8daf9be3668f.svg "facebook")](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss) [![gmail](/assets/social-logos/gmail-6db42f21e7c254fae201b112bef0dd15d25223a5cbb32691ce80eab43761eadf.svg "gmail")](https://mail.google.com/mail/?view=cm&fs=1&tf=1&to=&su=COZYROC+Solutions+Discussions+%7C+G2&body=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss%0aAsk+COZYROC+Solutions+questions+and+get+answers+from+expert+users+in+our+COZYROC+Solutions+Discussions+section.) [![mail](/assets/social-logos/mail-d55c53b04bf49872e40cd2443b85a99caa23394e6cf154ae32a9d08377c15d86.svg "mail")](mailto:?subject=COZYROC+Solutions+Discussions+%7C+G2&body=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss%0aAsk+COZYROC+Solutions+questions+and+get+answers+from+expert+users+in+our+COZYROC+Solutions+Discussions+section.) ![copy_link](/assets/social-logos/copy_link-05d8dc5dc8576fc78425ad34d07241b060878835e555a30417ff41c18335e575.svg "copy\_link") ## Start a New Software Discussion Have a software question? Get answers from real users and experts [Start A Discussion](/products/cozyroc-solutions/discussions/new) * * * ![Product Avatar Image](https://images.g2crowd.com/uploads/product/hd_favicon/8590bb54a53f6abd0fb677ed650cc64f/cozyroc-solutions.svg "Product Avatar Image") ### Have you used COZYROC Solutions before? Answer a few questions to help the COZYROC Solutions community [ Yes ](javascript:void(0))[ Yes ](https://www.g2.com/login?context=product_review&return_to=https%3A%2F%2Fwww.g2.com%2Fproducts%2Fcozyroc-solutions%2Fdiscuss%3Fsmall_ask%3Dcozyroc-solutions) No