# \#ssis **URL:** https://community.cdata.com/tag/ssis/51.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [Cannot Access Data in Sheet from SSIS Smartsheet Connector](https://community.cdata.com/t/cannot-access-data-in-sheet-from-ssis-smartsheet-connector/1302)
**Author:** [@Breadcrumb](https://community.cdata.com/u/Breadcrumb)\ **Replies:** 1\ **Last updated:** [June 15, 2026, 10:00pm UTC](https://community.cdata.com/t/cannot-access-data-in-sheet-from-ssis-smartsheet-connector/1302 "2026-06-15T22:00:10Z")
Hello, I have a particular SSIS Package that loads data from a Smartsheet into a SQL Server table via an OLE DB Destination component. This is a very standard setup at my org, and this exact package had been chugging al… --- ## [HRESULT: 0xC0047043 Exception when using SSIS components](https://community.cdata.com/t/hresult-0xc0047043-exception-when-using-ssis-components/1245)
**Author:** [@Bergi\_M](https://community.cdata.com/u/Bergi_M)\ **Replies:** 0\ **Last updated:** [December 2, 2025, 2:58pm UTC](https://community.cdata.com/t/hresult-0xc0047043-exception-when-using-ssis-components/1245 "2025-12-02T14:58:20Z")
While working with our SSIS components in Visual Studio, you may encounter an Exception from HRESULT: 0xC0047043 error: This is a known issue in Visual Studio SSIS project. It occurs because Visual Studio UI attemp… --- ## [Troubleshooting SSIS SFTP. "file:FileService SFTP Client Error during operation 'DOWNLOAD': The specified directory could not be created"](https://community.cdata.com/t/troubleshooting-ssis-sftp-file-fileservice-sftp-client-error-during-operation-download-the-specified-directory-could-not-be-created/1166)
**Author:** [@Derk](https://community.cdata.com/u/Derk)\ **Replies:** 1\ **Last updated:** [August 14, 2025, 7:29am UTC](https://community.cdata.com/t/troubleshooting-ssis-sftp-file-fileservice-sftp-client-error-during-operation-download-the-specified-directory-could-not-be-created/1166 "2025-08-14T07:29:19Z")
I’m trying to deploy an SSIS package to my server, and receiving the error “file:FileService SFTP Client Error during operation ‘DOWNLOAD’: The specified directory could not be created” server side. This runs without an… --- ## [SSIS with CData SSIS Components for Gmail fails when run on SQL server when run with proxy account](https://community.cdata.com/t/ssis-with-cdata-ssis-components-for-gmail-fails-when-run-on-sql-server-when-run-with-proxy-account/1096)
**Author:** [@GritKit](https://community.cdata.com/u/GritKit)\ **Replies:** 2\ **Last updated:** [May 28, 2025, 8:50pm UTC](https://community.cdata.com/t/ssis-with-cdata-ssis-components-for-gmail-fails-when-run-on-sql-server-when-run-with-proxy-account/1096 "2025-05-28T20:50:49Z")
The SSIS package runs fine on my local computer, but it fails with the following errors when run on the SQL Server. Here is our setup: Google API Client ID + Client Secret have been generated using service acco… --- ## ["The primary key must be specified to update a row" error - SSIS Destination components](https://community.cdata.com/t/the-primary-key-must-be-specified-to-update-a-row-error-ssis-destination-components/1015)
**Author:** [@Rodrigo\_de\_Albuquerque](https://community.cdata.com/u/Rodrigo_de_Albuquerque)\ **Replies:** 1\ **Last updated:** [January 31, 2025, 9:53pm UTC](https://community.cdata.com/t/the-primary-key-must-be-specified-to-update-a-row-error-ssis-destination-components/1015 "2025-01-31T21:53:23Z")
When trying to run an update with my CData SSIS Destination components, the job is failing with the following error: “The primary key must be specified to update a row”. What should I do to workaround this problem? --- ## [SSIS component - error on Microsoft.DataWarehouse assembly](https://community.cdata.com/t/ssis-component-error-on-microsoft-datawarehouse-assembly/1001)
**Author:** [@dvinge](https://community.cdata.com/u/dvinge)\ **Replies:** 1\ **Last updated:** [January 24, 2025, 4:53pm UTC](https://community.cdata.com/t/ssis-component-error-on-microsoft-datawarehouse-assembly/1001 "2025-01-24T16:53:48Z")
TITLE: Microsoft Visual Studio ------------------------------ Could not load file or assembly ‘Microsoft.DataWarehouse, Version=17.3.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. … --- ## [DBAmp upgrade with SSIS](https://community.cdata.com/t/dbamp-upgrade-with-ssis/811)
**Author:** [@jitendrapp](https://community.cdata.com/u/jitendrapp)\ **Replies:** 1\ **Last updated:** [July 26, 2024, 5:46pm UTC](https://community.cdata.com/t/dbamp-upgrade-with-ssis/811 "2024-07-26T17:46:18Z")
Hello, I will really appreciate your help with below question related to version upgrade. Our team is planning to upgrade DBAmp version from 4.1.8.to V2022.While going thorugh release notes ,came across with statement… --- ## [DBAmp upgrade to V2022 with SSIS](https://community.cdata.com/t/dbamp-upgrade-to-v2022-with-ssis/812)
**Author:** [@jitendrapp](https://community.cdata.com/u/jitendrapp)\ **Replies:** 1\ **Last updated:** [July 26, 2024, 5:41pm UTC](https://community.cdata.com/t/dbamp-upgrade-to-v2022-with-ssis/812 "2024-07-26T17:41:49Z")
Hello, I will really appreciate your help with below question related to version upgrade. Our team is planning to upgrade DBAmp version from 4.1.8.to V2022.While going thorugh release notes ,came across with statement… --- ## [Edit Generated Schema Files](https://community.cdata.com/t/edit-generated-schema-files/747)
**Author:** [@Naomi\_Y](https://community.cdata.com/u/Naomi_Y)\ **Replies:** 0\ **Last updated:** [June 5, 2024, 7:59pm UTC](https://community.cdata.com/t/edit-generated-schema-files/747 "2024-06-05T19:59:21Z")
In this article, I will outline how to edit a newly generated schema file using our Connectors. This article will use our QuickBooks Online Power BI Connector as an example; however, this walkthrough is applicable to any… --- ## [Freshbooks object error while using ssis cdata drivers](https://community.cdata.com/t/freshbooks-object-error-while-using-ssis-cdata-drivers/744)
**Author:** [@Renukachari\_Kasee](https://community.cdata.com/u/Renukachari_Kasee)\ **Replies:** 2\ **Last updated:** [June 5, 2024, 1:34am UTC](https://community.cdata.com/t/freshbooks-object-error-while-using-ssis-cdata-drivers/744 "2024-06-05T01:34:21Z")
Hi Ethem, i am able to connect freshbooks, except invoices object, all other objects are showing an error. kindly assist me on this. i am attaching an error image please check and suggest Thanks, Chari --- ## [NetSuite SSIS connector issue](https://community.cdata.com/t/netsuite-ssis-connector-issue/739)
**Author:** [@TheDataDevs](https://community.cdata.com/u/TheDataDevs)\ **Replies:** 1\ **Last updated:** [June 4, 2024, 5:03pm UTC](https://community.cdata.com/t/netsuite-ssis-connector-issue/739 "2024-06-04T17:03:42Z")
I am creating a simple ETL package in Visual Studio 2022. I have a data flow using Cdata DataSource, and an OLE DB as the destination. I open the cdata netsuite source editor, select the transaction via and hit ok and vi… --- ## [“\[INVALID\_PARAMETER\] Invalid search query” error when trying to query NetSuite tables](https://community.cdata.com/t/invalid-parameter-invalid-search-query-error-when-trying-to-query-netsuite-tables/741)
**Author:** [@DylanO](https://community.cdata.com/u/DylanO)\ **Replies:** 0\ **Last updated:** [June 3, 2024, 7:19pm UTC](https://community.cdata.com/t/invalid-parameter-invalid-search-query-error-when-trying-to-query-netsuite-tables/741 "2024-06-03T19:19:10Z")
When using any of our NetSuite connectors, you may see the following error when trying to query a table: \[INVALID\_PARAMETER\] Invalid search query. Detailed unprocessed description follows. Search error occurred: Field ‘\<… --- ## [unable to connect Freshbooks using Cdata SSIS component](https://community.cdata.com/t/unable-to-connect-freshbooks-using-cdata-ssis-component/737)
**Author:** [@Renukachari\_Kasee](https://community.cdata.com/u/Renukachari_Kasee)\ **Replies:** 2\ **Last updated:** [May 31, 2024, 8:37pm UTC](https://community.cdata.com/t/unable-to-connect-freshbooks-using-cdata-ssis-component/737 "2024-05-31T20:37:01Z")
Hi Team, i am unable to connect my freshbooks using Cdata connection kinldy share me the connection properties. in Freshbooks site there is an option to create app under that app all settings are attached as an attach… --- ## [Downgrading CData SSIS edition drivers](https://community.cdata.com/t/downgrading-cdata-ssis-edition-drivers/717)
**Author:** [@Andrew\_H](https://community.cdata.com/u/Andrew_H)\ **Replies:** 0\ **Last updated:** [May 15, 2024, 7:01pm UTC](https://community.cdata.com/t/downgrading-cdata-ssis-edition-drivers/717 "2024-05-15T19:01:38Z")
Customers may have issues with preexisting connection managers for their packages if they downgrade without performing the proper steps. This fix should theoretically apply to non-CData drivers as well. Common issues in… --- ## [Deploy CData SSIS Components on Azure Data Factory](https://community.cdata.com/t/deploy-cdata-ssis-components-on-azure-data-factory/78)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 1\ **Last updated:** [May 10, 2024, 10:54pm UTC](https://community.cdata.com/t/deploy-cdata-ssis-components-on-azure-data-factory/78 "2024-05-10T22:54:39Z")
Azure Data Factory is a scalable, trusted, cloud-based solution for building automated data integration solutions with a visual, drag-and-drop UI. Moving on-premises SSIS workloads to Azure can reduce the operational cos… --- ## [unable to view the data from customerinvocies view](https://community.cdata.com/t/unable-to-view-the-data-from-customerinvocies-view/709)
**Author:** [@Renukachari\_Kasee](https://community.cdata.com/u/Renukachari_Kasee)\ **Replies:** 3\ **Last updated:** [May 7, 2024, 3:06pm UTC](https://community.cdata.com/t/unable-to-view-the-data-from-customerinvocies-view/709 "2024-05-07T15:06:34Z")
Hi Ethem, i am unable to the data in customerinvoices object. any filters do we need to appliy kindly help me. i have attached the error images please check.. Thanks, Chari --- ## [Unable to schedule the CData SSIS job in sql server Agent job.](https://community.cdata.com/t/unable-to-schedule-the-cdata-ssis-job-in-sql-server-agent-job/703)
**Author:** [@Renukachari\_Kasee](https://community.cdata.com/u/Renukachari_Kasee)\ **Replies:** 1\ **Last updated:** [April 26, 2024, 10:32pm UTC](https://community.cdata.com/t/unable-to-schedule-the-cdata-ssis-job-in-sql-server-agent-job/703 "2024-04-26T22:32:12Z")
Hi Ethem Q, i have created the ssis package using the CData workday drivers. package is running smoothly when it is in SSIS compailor. and i am trying to schedule this package as agent job in sql server, it is failing w… --- ## [Unabale to see the user created workday views/datasets on CData SSIS connector](https://community.cdata.com/t/unabale-to-see-the-user-created-workday-views-datasets-on-cdata-ssis-connector/681)
**Author:** [@Renukachari\_Kasee](https://community.cdata.com/u/Renukachari_Kasee)\ **Replies:** 3\ **Last updated:** [April 26, 2024, 7:13pm UTC](https://community.cdata.com/t/unabale-to-see-the-user-created-workday-views-datasets-on-cdata-ssis-connector/681 "2024-04-26T19:13:20Z")
Hi Team, in workday SSIS cdata connector whatever my team has been created new views based on workday system datasets are not visible on views dropdown list. is there any permissions issue? or user created views we w… --- ## [Help with CData SAPERP RFC parameters](https://community.cdata.com/t/help-with-cdata-saperp-rfc-parameters/696)
**Author:** [@cbaptista](https://community.cdata.com/u/cbaptista)\ **Replies:** 1\ **Last updated:** [April 19, 2024, 3:41pm UTC](https://community.cdata.com/t/help-with-cdata-saperp-rfc-parameters/696 "2024-04-19T15:41:41Z")
Hello everybody! I’m facing the following situation when trying to execute an RFC trought CData connector for SAP ERP… In SAP, I’ve created an RFC to retrieve additional data for our needs, it works and have these pa… --- ## [Building Dynamic Queries in the Expression Builder – The data types "DT\_WSTR" and "DT\_I4" are incompatible for binary operator "+".](https://community.cdata.com/t/building-dynamic-queries-in-the-expression-builder-the-data-types-dt-wstr-and-dt-i4-are-incompatible-for-binary-operator/692)
**Author:** [@IrdiD](https://community.cdata.com/u/IrdiD)\ **Replies:** 0\ **Last updated:** [April 9, 2024, 8:50pm UTC](https://community.cdata.com/t/building-dynamic-queries-in-the-expression-builder-the-data-types-dt-wstr-and-dt-i4-are-incompatible-for-binary-operator/692 "2024-04-09T20:50:46Z")
The issue arises when trying to Evaluate an expression that contains a normal SQL Query and attempting to use a UserDefined Variable in the Expressions that have a data type other than WSTR (string). The error tells us t… --- ## [SAP Function READ\_TEXT](https://community.cdata.com/t/sap-function-read-text/661)
**Author:** [@cbaptista](https://community.cdata.com/u/cbaptista)\ **Replies:** 2\ **Last updated:** [March 26, 2024, 7:34pm UTC](https://community.cdata.com/t/sap-function-read-text/661 "2024-03-26T19:34:55Z")
Hi everyone! I would like to know if is it possible to retrieve data from the SAP ECC 6.0 Function READ\_TEXT, using the CData SSIS Components for SAP ERP 2023. Thanks. --- ## [Error from Workday SSIS connector extention question](https://community.cdata.com/t/error-from-workday-ssis-connector-extention-question/666)
**Author:** [@Renukachari\_Kasee](https://community.cdata.com/u/Renukachari_Kasee)\ **Replies:** 3\ **Last updated:** [March 20, 2024, 6:56pm UTC](https://community.cdata.com/t/error-from-workday-ssis-connector-extention-question/666 "2024-03-20T18:56:12Z")
Hi Ethem, thanks for your replay, i have updated the latest drivers in my system. after that i can see the WQL extension objects. all objects i can see but however i am seeing some more problem in this query i am attac… --- ## [Error from Workday SSIS connector](https://community.cdata.com/t/error-from-workday-ssis-connector/664)
**Author:** [@Renukachari\_Kasee](https://community.cdata.com/u/Renukachari_Kasee)\ **Replies:** 7\ **Last updated:** [March 15, 2024, 6:42pm UTC](https://community.cdata.com/t/error-from-workday-ssis-connector/664 "2024-03-15T18:42:25Z")
Hi Team, while connecting Workday Cdata SSIS connector below error is coming kidnly advise. “Invalid FROM clause starting with character: 6405. Invalid WQL syntax.” i am using below query from workday. select \* fro… --- ## [Upsert Salesforce Data using External Id in SSIS](https://community.cdata.com/t/upsert-salesforce-data-using-external-id-in-ssis/657)
**Author:** [@Andrew\_H](https://community.cdata.com/u/Andrew_H)\ **Replies:** 0\ **Last updated:** [March 11, 2024, 2:27pm UTC](https://community.cdata.com/t/upsert-salesforce-data-using-external-id-in-ssis/657 "2024-03-11T14:27:03Z")
First, set up the data source. A Salesforce source is used in this example, but any source will work for this process. Drag a Derived Column transformation component from the Data Flow Transformations section of … --- ## [“BatchSize” in SSIS](https://community.cdata.com/t/batchsize-in-ssis/545)
**Author:** [@ReiM](https://community.cdata.com/u/ReiM)\ **Replies:** 0\ **Last updated:** [November 30, 2023, 10:57pm UTC](https://community.cdata.com/t/batchsize-in-ssis/545 "2023-11-30T22:57:52Z")
In general, it’s important to keep in mind that when using our CData drivers alongside various tools, one must consider the configurations and properties of these tools, as they can potentially override drivers’ configur… --- ## [SSIS- Unable to bind the parameter](https://community.cdata.com/t/ssis-unable-to-bind-the-parameter/507)
**Author:** [@Erjol\_Sulku](https://community.cdata.com/u/Erjol_Sulku)\ **Replies:** 0\ **Last updated:** [November 3, 2023, 7:59pm UTC](https://community.cdata.com/t/ssis-unable-to-bind-the-parameter/507 "2023-11-03T19:59:46Z")
This error is encountered while working with SSIS (SQL Server Integration Services) and utilizing parametrized queries. There are a couple of common reasons why you might encounter this error: 1. You are using a paramet… --- ## [Error to read a view from a MongoDB SSIS Components](https://community.cdata.com/t/error-to-read-a-view-from-a-mongodb-ssis-components/493)
**Author:** [@Gleison\_AR](https://community.cdata.com/u/Gleison_AR)\ **Replies:** 1\ **Last updated:** [October 26, 2023, 10:05pm UTC](https://community.cdata.com/t/error-to-read-a-view-from-a-mongodb-ssis-components/493 "2023-10-26T22:05:50Z")
Hey guys, I´ve facing an error with this MongoDB component. When I´m trying to setup my data flow at SSIS, I´m facing an error warning that the view that I´ve setup doesn´t exist look to screen shot below: The pro… --- ## [Test Connection failed. OAuth authentication failed](https://community.cdata.com/t/test-connection-failed-oauth-authentication-failed/459)
**Author:** [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\ **Replies:** 0\ **Last updated:** [October 13, 2023, 9:31pm UTC](https://community.cdata.com/t/test-connection-failed-oauth-authentication-failed/459 "2023-10-13T21:31:43Z")
This error frequently arises when the OAuth flow hasn’t been initialized. It’s important to note that while this issue is more common in SSIS it is not limited to SSIS components only; it can also occur in various editio… --- ## [Error “504 Gateway Timeout” while using CData Salesforce Pardot SSIS connector](https://community.cdata.com/t/error-504-gateway-timeout-while-using-cdata-salesforce-pardot-ssis-connector/407)
**Author:** [@Kristjana\_Mato](https://community.cdata.com/u/Kristjana_Mato)\ **Replies:** 0\ **Last updated:** [September 20, 2023, 6:42pm UTC](https://community.cdata.com/t/error-504-gateway-timeout-while-using-cdata-salesforce-pardot-ssis-connector/407 "2023-09-20T18:42:22Z")
While retrieving data from the ‘Visitor Activities’ view in Salesforce Pardot, after more than two minutes we get an error “504 Gateway Timeout” and no records are returned. It happened because of the number of records t… --- ## [Issue With Cadata Excel Connection On New 2019 SQL Server](https://community.cdata.com/t/issue-with-cadata-excel-connection-on-new-2019-sql-server/341)
**Author:** [@varunsharma13](https://community.cdata.com/u/varunsharma13)\ **Replies:** 1\ **Last updated:** [September 15, 2023, 10:19am UTC](https://community.cdata.com/t/issue-with-cadata-excel-connection-on-new-2019-sql-server/341 "2023-09-15T10:19:40Z")
Current servers are running with SQL 2016 version and in these servers we have CData.SSIS.Excel (18.0.6705) with 2018 version. This Cdata version is running fine in current server. In the new server which is running on… [Next page](https://community.cdata.com/tag/ssis/51.md?match_all_tags=true&page=1&tags%5B%5D=ssis)