Forum

Syndicate content
This is a newsgroup for discussing COZYROC family of products. Enjoy.
Updated: 11 hours 22 min ago

Re: Trying to unzip Zipped file

Fri, 04/29/2016 - 11:03
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
Categories: News

Re: Data Flow Task Plus isn't doing anything

Fri, 04/29/2016 - 07:25
Nothing unusual there. I can post it if you like. Cris
Categories: News

Re: Visual Studio 2015 compatibility.

Thu, 04/28/2016 - 19:00
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:
Categories: News

Re: How to move multiple files between SFTP Folders

Fri, 04/22/2016 - 16:54
In the SFTP Task specify: OldName : /inbound/*.csv NewName: /inbound/Completed/
Categories: News

CRM2015 SSIS Cozyroc Connection Mgr - Token node not found.

Wed, 04/20/2016 - 15:52
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
Categories: News

Re: Required fields?

Mon, 04/18/2016 - 13:14
yes
Categories: News

Re: 1 Server, 3 Devs license question

Mon, 04/18/2016 - 07:48
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
Categories: News

Re: importing from XLSM files

Wed, 04/13/2016 - 08:04
Hi Nick, COZYROC's Excel adapters can handle XLSM files.
Categories: News

Re: Exchange Connector

Thu, 04/07/2016 - 22:18
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?
Categories: News

Re: FTPS Connection and SFTP Task

Tue, 03/29/2016 - 14:00
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.
Categories: News

Re: SFTP Send failing

Tue, 03/29/2016 - 14:00
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
Categories: News

Re: SSIS - Connect MYSQL

Sun, 03/20/2016 - 07:36
Hi Guilherme, There must be other error messages. Please post the complete list of errors. Thank you!
Categories: News

Re: Data flow task plus error occured

Sat, 03/19/2016 - 21:46
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.
Categories: News

Re: CozyRoc SSIS+ 1.6 Trial Ver - Oracle Destination Error / Failed to initialize bulk-load support

Fri, 03/18/2016 - 15:21
I'm having the same issue, FWIW. Any resolution info?
Categories: News

Re: s3 task license details

Thu, 03/17/2016 - 00:14
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.
Categories: News

Re: CRM Dynamics Connection Manager

Tue, 03/15/2016 - 09:16
Hi Diana, You have to provide credentials to access the CRM.
Categories: News

Re: MongoDB ??

Fri, 03/11/2016 - 15:15
Hi SD, We do not provide components for connection to MongoDB at this time .
Categories: News

Re: Script Component Plus Dynamic Columns

Wed, 03/09/2016 - 22:08
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
Categories: News

Re: BIML using Salesforce Source

Wed, 03/09/2016 - 14:15
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)?
Categories: News

Re: Salesforce Unsupported Client TLS 1.0

Fri, 03/04/2016 - 22:53
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
Categories: News