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

Re: Access to the path 'C:\Program Files(x86)\CozyRoc\SSIS\License.dat' is denied

Tue, 05/24/2016 - 17:56
Hi Dermot, You have not provided the required permissions as described in the instructions. I would recommend you review the instructions again.
Categories: News

Re: Salesforce Source - Refresh Generates XML Document Instance Validation Error

Wed, 05/18/2016 - 08:10
Great! Don't know what caused it, but it's an easy workaround. Last idea was the best.
Categories: News

Re: Data Flow Task Plus isn't doing anything

Wed, 05/18/2016 - 06:58
Replying to myself, to document the solution I found. I hope it will be of some help to others having the same problem. First of all: the cause of the problem is that DFTP is unable to correctly retrieve the columns from DB2 when the table name is an alias. I was dealing with aliases, so I had to
Categories: News

Re: SharePoint Update does not update field with Null.

Tue, 05/17/2016 - 15:24
Hi Dave, This behavior is by design. If you want to reset field , pass empty string as input.
Categories: News

Re: Can the EDI components be used to process varying record types in a single file?

Wed, 05/11/2016 - 09:02
Dave, "reached end of mapping model" means there is incoming input data which is not describe in the layout you have defined.
Categories: News

Re: "Excel Connection Manager 1" is not recognized as a valid connection manager type.

Tue, 05/10/2016 - 17:47
Beth, If you search for CozyRoc.SSISPlus*.dll file , you should find the file present in both "C:\Program Files (x86)" and "C:\Program Files" .
Categories: News

Re: Is it possible to create dynamic SSIS package to load data into multiple table using OLEDB to OLED

Tue, 05/10/2016 - 17:45
Manoj, What happens when you double-click or click on Edit... ?
Categories: News

Re: EDISource Configuration File Supporting Component and Sub-component Elements

Sat, 05/07/2016 - 09:42
There error message says you have a 'component' element directly inside a 'segment' element, which is not allowed. To fix the error remove the closing slash on the opening field element as highlighted below:
Categories: News

Re: Salesforce Lookup Transformation Malformed_query

Tue, 05/03/2016 - 18:52
Hi Ivan, As you probably guessed, my package protection level was set on "Don't Save Sensitive". So the SalesforceObject parameter was lost at run-time. I didn't know that the script parameters was considered sensitive. I should have known. Anyway, thx a lot for your help. Alexis
Categories: News

Re: Script Component Plus Configuring Dynamic Flow Fuzzy Lookup

Tue, 05/03/2016 - 18:51
Hi Ryan, If you are getting the error below you either don't have the SSIS+ library installed or the library is not installed properly. I would recommend you uninstall and then reinstall the SSIS+ library. Also check whether the machine you believe you are executing on is the actual machine
Categories: News

Re: SFTP Task Error: File represented by "/somefolder" does not exist

Mon, 05/02/2016 - 22:17
I am receiving the same error. the task is the exact same error. I can reach the files and pull them down using filezilla. however I run any packages (now) and get the same error.
Categories: News

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: 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
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 \\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