This is a newsgroup for discussing COZYROC family of products. Enjoy.
Updated: 14 hours 32 min ago
Hi Dermot, You have not provided the required permissions as described in the instructions. I would recommend you review the instructions again.
Great! Don't know what caused it, but it's an easy workaround. Last idea was the best.
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
Hi Dave, This behavior is by design. If you want to reset field , pass empty string as input.
Dave, "reached end of mapping model" means there is incoming input data which is not describe in the layout you have defined.
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" .
Manoj, What happens when you double-click or click on Edit... ?
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:
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
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
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.
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
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.