This is a newsgroup for discussing COZYROC family of products. Enjoy.
Updated: 11 hours 22 min ago
Hi Ivan, I finally figured out the issue, I have to change two things. It seems like Under CozyRoc Zip task, Dynamic Expressions wont work and lesson learnt here. 1) I have "Delay Validation to True" which concluded me to no issue and after changing to "False", I can see the issue on the "Zip
Nothing unusual there. I can post it if you like. Cris
I had the same problem. Ivan's talking about the "Deployment Target Version" setting in the project (not solution) properties in Visual Studio: Right click on the project and select properties. Click on the Configuration Properties on the left-hand tree. The "General" tab has a single option:
In the SFTP Task specify: OldName : /inbound/*.csv NewName: /inbound/Completed/
I created a simple SSIS package which was running correctly nightly via an SQL Server job. I used a login and password in the SSIS Dynamics CRM Connection Manager. the password was changed at AD level and the job stopped running. I went into the SSIS package in Visual Studio and updated my
Ivan, Thanks for the reply. So, given we have three developers and one server to run Agent jobs that means two licences is what I am hearing. I'll proceed with my request for two Ultimate licences based upon that understanding. 1 Server + 3 Developers = 4 licences = 2 Ultimate packages Thanks
Hi Nick, COZYROC's Excel adapters can handle XLSM files.
Is a service account the same thing and a shared mailbox. I tried setting mailbox to \MyShare...@address.com\Inbox. It Tests fine, but when i run it i still get emails from my personal inbox, not the shared inbox. Anybody else had success with this?
FTPS is not the same thing as SFTP. If you are connecting to an SFTP server that rejects SSL (which is the security that FTPS uses), your connection will fail. You need to use the SSH Connection Manager, which is the type of connection required for an SFTP server.
I recently received this error, and it was actually due to the location in which I was sending the SFTP. I had my FTP path as /Root/Parent Directory/In. The login I was using had been configured to open at /Root/Parent Directory/, so what I was actually using as my file path was /Root/Parent
Hi Guilherme, There must be other error messages. Please post the complete list of errors. Thank you!
I usually get this error when I have the data flow task plus property DelayValidation set to true, this is the one thing you want to remain as false.
I'm having the same issue, FWIW. Any resolution info?
Hi Alok, When you test and develop from Visual Studio (BIDS), no license key is required. A license key is required for each physical machine where you want to schedule and execute packages under SQL Job agent.
Hi Diana, You have to provide credentials to access the CRM.
Hi SD, We do not provide components for connection to MongoDB at this time .
First off I will say CozyRoc is the best set of components I have ever encountered. For the most part our ETL developers spend no time doing work in SSIS itself anymore as we are 98% configuration based etl. We have 1 primary SSIS package that handles all of processes and we have a lot, we
Hi Eugene, I know this is an old thread, but would you be willing to share your biml code for the Salesforce Source (CustomComponent code)?
I have that issue using SQL 2012 R2 and the fix was related to .NET settings. https://help.salesforce.com/apex/HTViewSolution?id=000221207#Inboundintegrations "It may be possible to enable TLS 1.2 by default without modifying the source code by setting the SchUseStrongCrypto DWORD value in the