FAQ
How to Retrieve SharePoint Site and Subsite GUID
This article provides step-by-step instructions to retrieve the GUID (Globally Unique Identifier) for a SharePoint site and its subsites Retrieve the SharePoint Site GUID To get the GUID of a SharePoint site, use the following URL structure and copy ...Erro
Action: When running a package in Visual Studion with Exchange Connection created with token file, the package runs successfully. However, when deploying the package to the server, the following error message is generated. Error Message: ''Invalid ...How to specify filter parameter for Oracle Eloqua Export and Import Definition
You will have to replace the open curly brackets mentioned in Oracle Eloqua documentaion here with the symbol ( < ) and closing curly brackets with symbol ( > ) as mentioned below. "filter":"'<Activity.Type>'='FormSubmit'"How to Register your app on Azure Portal Quick Start
Registering your application establishes a trust relationship between your app and the Microsoft identity platform. The trust is unidirectional: your app trusts the Microsoft identity platform, and not the other way around. Follow the steps to create ...Guide to REST API Connections in CozyRoc SSIS+: Introduction
Guide to REST API Connections in CozyRoc SSIS+ This guide will show you how to use CozyRoc SSIS+ to make connections to third-party integrations, web services with REST APIs that enable you to extract, transform, and load data across the internet. ...Guide to REST API Connections in CozyRoc SSIS+: Introduction
Guide to REST API Connections in CozyRoc SSIS+ This guide will show you how to use CozyRoc SSIS+ to make connections to third-party integrations, web services with REST APIs that enable you to extract, transform, and load data across the internet. ...How to flatten composite records from Rest Source
Many real-world applications need to handle data structures which can't be represented with a simple flat table. A good example is an invoice record where each record contains a sub-list of line item records. For each main object, which identifies ...HEADER PARAMETERS, E-Tag
Issue with the documentation. The E-Tag is required for both delete and update operations. After adding it for elete and upate customer was able to successfullya ble to delete and update records.Considerations when choosing REST token storage
Since version 2.1 in COZYROC SSIS+ access tokens used by REST Connection Manager can be stored not only in the file system, but also in a database (SQL Server). Using such a centralized storage addresses the following complications with the ...Where can I find the documentation for the Azure Table Connection?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Azure Table Connection can be found at the following link. For many of the components you can find ...Where can I find the documentation for the Amazon Athena Connection?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Amazon Athena Connection can be found at the following link. For many of the components you can find ...Error Message:Combined execution time of incoming requests exceeded limit of 1200000 milliseconds over time window of 300 seconds.
Action: We started having random failures with an SSIS package that loads data from SQL Server to Dynamics (and back). Error Message: “Combined execution time of incoming requests exceeded limit of 1200000 milliseconds over time window of 300 ...Error Message:Combined execution time of incoming requests exceeded limit of 1200000 milliseconds over time window of 300 seconds.
Action: We started having random failures with an SSIS package that loads data from SQL Server to Dynamics (and back). Error Message: “Combined execution time of incoming requests exceeded limit of 1200000 milliseconds over time window of 300 ...ADP Connection Manager unable to retrieve all the records
Action: When executing a package using Data Flow Task Plus to retrieve all the records. Error: ''Unable to retrieve ." Solution: This issue can occur if the BatchSize in Rest Source is above 100. Previously one of the customer had reported the same ...ADP Connection Manager Out of Memory Error Message
Solution: The out of memory error occurs because of the excessive field Metadata. To overcome this issue, right click on REST SOURCE and select Advance Editor to remove the External columns and Output columns that you don't need. If there is a child ...How to Register your app on Azure Portal Quick Start
Registering your application establishes a trust relationship between your app and the Microsoft identity platform. The trust is unidirectional: your app trusts the Microsoft identity platform, and not the other way around. Follow the steps to create ...When to connect to MongoDB replica set?
You should connect to MongoDB replica set only when you have multiple hosts.How to configure the Excel Source Plus component to use particular worksheet when the sheet name is unknown?
If you are planning to use only the first worksheet in the Excel file, but the worksheet name is unknown then the steps below should be completed: 1) Make sure that you are using 2.0 version of COZYROC SSIS+ and up, because this feature to reference ...How to setup your client_id and client_secret values to connect with COZYROC Microsoft Dataverse Connector and Exchange Connector
This KB-Article explains how you can setup your own client_id and client_secret values instead of using default COZYROC app client id to connect with Microsoft Dataverse Connector and Exchange Connector. You can do all of your administrative tasks ...Where can I find the documentation for the Address Parse?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Address Parse can be found at the following link. For many of the components you can find resources ...How to select OpenAPI/Swagger file using COZYROC OpenAPI Import Wizard
The OpenAPI import wizard (introduced in 2.0 release) enables quick, automated creation of resources, endpoints, parameters and fields from an OpenAPI specification (formerly Swagger specification). To learn more about OpenAPI see here. By following ...Where can I find the documentation for the Infusionsoft Connection?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. https://www.cozyroc.com/ssis/infusionsoft-connection For many of the components you can find resources like an overview, additional ...Error message: LDAP Source error: Failed to process {...} for column {Column Name}
Action: When using LDAP Source component I get the following error: Error Message: LDAP Source error: Failed to process {...} for column {Column Name} Solution: Most likely the Output Column is not large enough to accommodate the input text . To ...Error Message: Microsoft.ACE.OLEDB.12.0 is not registered.
Action: We have packages that use COZYROC EXCEL Task and we are getting the following error message. Error Message: Error Message: Microsoft.ACE.OLEDB.12.0 is not registered. Solutions: COZYROC Excel connector is not using Microsoft’s modules, so ...
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Popular Articles
How To verify Microsoft Integration Services is installed on SQL Server
SQL Server Integration Services (SSIS) is a component of SQL Server and can be installed with or without SQL Server. The same SQL Server setup can be used to install Integration Services on the server that SQL Server is installed on. SSIS is a ...FLEE Expressions for filtering
FLEE expressions are used to define criteria for filter parameters in several COZYROC tasks and components. FLEE is a “Fast, Lightweight Expression Evaluator.” Finding documentation to help you configure a valid expression can be challenging. The ...I see a response returned from the web service, but the preview in REST Source does not show any data.
CozyRoc Rest Source Component allow you to Read data from REST API. Developer can quickly extract response data from desire endpoint using HTTP Method (GET, POST) and Output into column data. In this article we will walk through some examples that ...How long is the grace period after the subscription has expired?
We noticed that our license is going to expire soon and we are in the process of renewing the license and it might take couple of days. We are wondering if you can provide a solution to use your product in our production system temporarily without ...How to resolve File Transfer Task failing when no files exist.
This KB article is not relevant if you are using "Get Remote Files List" action on File Transfer Task. Instead, you can use this COZYROC prepared Javascript: https://www.cozyroc.com/ssis/script-ftp-file-exists-task If you are not sure there will be ...