Hi, Check the documentation page here under the title: How to include the missing columns when using an SOQL statement
Thank you very much, appreciate your help.
Hi, Check your expression used to setup the SOQL statement. Most probably the issue is there.
Marcel, You have to provide both read/write explicit permissions to the License.dat file for the user account you use under SQL Job agent. All of this and more is explained on the license instructions page here.
We've just released a massive update of the COZYROC SSIS+ 1.7 Beta 2 Library ! In addition to all the REST services supported in the first beta release this update will help you to EXPAND your connectivity to popular CLOUD services like:
Click here to download the beta release of COZYROC SSIS+ 1.7 library
In addition to the many improvements and fixes in the REST adapters, the adapters now also include support for composite objects.
Developing and testing is completely free and you don't need a license key.
If you have any questions or comments, please let us know. We're here for you.
The COZYROC Team
Hi Dylan, Based on your description I would say the issue is not COZYROC DFT+ but the fact SELECT * ... statement doesn't return the appropriate columns information. You have to find how you can make the database provide all columns information . Then I suspect the DFT+ will work just fine.
Hi Nikhil, You can use VS 2010 or VS 2012 for SQL Server 2012 development.
Hi Nikhil, Switch the solution to SQL Server 2012 or 2014 mode and you should see COZYROC's components appear in the custom SSIS Toolbox.
Hi Nikhil, When you test and develop from Visual Studio (BIDS), no license key is required.
Hi Dona, You have to setup SSIS expression to modify the ObjectFilter parameter at runtime. I would recommend you check the "Dynamic Query" demo video from the documentation page here.
Hey Patrick - We're running into this issue with one of our Sandboxes and are trying to be proactive about it before Production switches to TLS 1.1. The problem we face is that our I.T. department has all of our machines heavily locked-down and we can't make any updates that require admin
Hi Azmi, The SSH connection manager is not related to the TLS protocol. TLS applies to the FTPS connection manager.
Hi, I believe you should be able to use Project parameters in the Salesforce connection manager.
Hi, Either your setup is incorrect. Or the data between the old and new input is different. If you believe that is not the case, send a complete test package and input data to COZYROC's support and we will analyze it further.
Hi, Use COZYROC Salesforce Destination component to update records.
Hi Brett, When you test and develop from Visual Studio (BIDS), no license key is required. A license key is required if you want to schedule and execute packages under SQL Job agent.
We recently had a client deliverable that involved pulling data from a MySQL instance. This also required us to open an SSH tunnel in order to establish the connection. This post is to help anyone else out that experiences a similar scenario and gets stuck the way we did. We have been COZYROC
Hi, COZYROC's Salesforce adapters depend on the .NET framework for support of the HTTPS protocol. SQL Server 2008 R2 is based on .NET 3.5 framework which doesn't support TLS 1.1 or 1.2 by default. Microsoft provides patch for .NET 3.5.1 which claims it could enable support for the missing
Right-click on the SharePoint connection manager and select Properties. Set RetainSameConnection=False . Try now to execute your package.