updated File Transfer Task

Site - Mon, 01/16/2017 - 04:00
Thu, 01/05/2017 - 15:49

updated File Transfer Task

Re: cozy roc remote file list help

Forum - Wed, 01/11/2017 - 11:01
Hi Ivan, We found out what the issue is. We changed the code to a list. Here is the code. I wanted to put this out there in case someone else in the future runs into this issue. Public Sub Main() Dim list() As Object = Dts.Variables("User::RemoteFileList").Value If
Categories: News

Re: Column missing in Salesforce Source Connector

Forum - Tue, 01/10/2017 - 19:53
We got it resolved. We were calling the wrong API to Sales Force. Once we fixed that the problem is resolved. Thanks. Razzakul Chowdhury (Raz)
Categories: News

Re: REST Source - ServiceNow

Forum - Mon, 01/09/2017 - 07:53
Hi, Please post if there is metadata returned for the field and if so what does it show. Thank you!
Categories: News

COZYROC SSIS+ 1.7 now officially released

Blog - Thu, 01/05/2017 - 10:42

Happy New 2017!

We are happy to announce the official release of the COZYROC SSIS+ 1.7 library. This new release brings groundbreaking technology, simplifying the connection and interaction with cloud applications in SSIS. This is only the start and our team plans to include support for many additional cloud applications shortly. We would like to thank our families, friends and customers for their support and patience. We look forward to hearing your feedback, thoughts and success stories. Cheers!

Summary of the products available immediately for purchase:
  • SSIS+ Ultimate Subscription at $399.95/Year
  • SSIS+ 1.7 perpetual license at $3,999.95
  • SAS® Adapters license at $2,499.95
  • USPS Address Database / One time purchase at $299.95
  • USPS Address Database / Monthly Subscription at $2,399.95/Year
  • SSIS+ Premium Support at $499.95/Year

For more information, check the purchase page.

Summary of the new / updated components
Categories: News

Re: Using IsDirectory in remote filter

Forum - Wed, 01/04/2017 - 19:24
Mike, You can use this reusable script to check if remote file or folder exists. Use the script with COZYROC Script Task Plus.
Categories: News

Re: FEL combining Excel Task Plus and Excel Source Plus

Forum - Wed, 01/04/2017 - 14:38
I finally got it to work, but I'm honestly not sure how. Right now, I have that Excel Connection manager set up with 2 expressions. One is for the connection string and one is for the Excel File Path. I have them both set to use the results of that first FEL workbook loop. It's working so I'm
Categories: News

Re: EDI Source Regular Expression Syntax

Forum - Tue, 01/03/2017 - 10:14
Hello, We use the regular .NET Regex class for processing the regular expressions. This regular expression looks fine: NM1\*(IL|74)
Categories: News

Re: Excel Task -- Results Variable data type

Forum - Wed, 12/28/2016 - 17:44
Hi Leigh Anne, Change the For Each Loop to Foreach from Variable Enumerator and everything will be fine from there.
Categories: News

Released COZYROC SSIS+ 1.7 Beta 3

Blog - Thu, 12/22/2016 - 20:45

We have just released COZYROC SSIS+ 1.7 Beta 3 Library. The new beta includes additional refinements in the new REST adapters. We have also included support for the following cloud services:

We are also happy to report we have included the following additional capabilities in the REST adapters:

  • Ability to define multiple authentication mechanism in the same configuration file.
  • Ability to extend base configuration metadata with user-defined metadata. The metadata can be extended both in the REST Source and REST Destination components.

Developing and testing is completely free and you don't need a license key.

Click here to download the beta release of COZYROC SSIS+ 1.7 library

If you have any questions or comments, please let us know. We're here for you.


Categories: News

Re: Data Flow Task Plus - Multiple SQL views to multiple flat_files

Forum - Tue, 12/20/2016 - 10:03
Leigh Anne, Congratz! ;) Without knowing what you did have setup in the previous packages, it is hard to tell what is wrong. The Mapping parameter has to be setup only if the destination columns differ from the source columns. The ColumnDelimiter parameter has to be setup, but if you are setting
Categories: News

Re: Install problems

Forum - Thu, 12/15/2016 - 16:23
BJ, The parent segment elements should be present in the output setup for the repeating segment "Member Identifier" . Check your columns.
Categories: News

Re: Salesforce SSIS connector & DT_DBTIMESTAMPOFFSET

Forum - Wed, 12/14/2016 - 12:40
Hi Tad, By default the date/time columns extracted from Salesforce are converted to the server's local time. You can use Time Zone Transformation reusable script here to convert the date/time columns to the timezone you prefer.
Categories: News

Re: EDI Source - XML Mapping

Forum - Wed, 12/14/2016 - 11:01
Jeffry, Change only the output column metadata. Do not modify the external column metadata. In this way the smart refresh will not change your output column setup.
Categories: News

Re: How to use SSH Execute task

Forum - Fri, 12/02/2016 - 08:36
Hi Gediminas, You can specify FLEE expression in the RemoteFilter parameter to select files after certain date/time.
Categories: News

Re: Projected Production Release of COZYROC 1.7

Forum - Wed, 11/30/2016 - 12:11
Hi Regor, We plan to release SSIS+ 1.7 officially in December, 2016.
Categories: News

Re: Receiving File error when the file does not exist in the SFTP task

Forum - Tue, 11/29/2016 - 08:37
I had the same problem and your solution worked for me. Thanks :) Asif
Categories: News

Re: Version 1.6 won't uninstall

Forum - Fri, 11/18/2016 - 07:25
In case anyone else has a similar problem I finally managed to get Version 1.6 uninstalled by using IObit Uninstaller, having had no success with the Microsoft uninstaller tool nor a couple of others.
Categories: News

Re: Custom Configurations for REST Connection

Forum - Thu, 11/17/2016 - 16:32
Jeff, Yes, you can create your own configurations for the REST connection manager. That is one of the major benefits of this technology.
Categories: News

SSIS+ - Deploy 1.7 Zip Task SQL Server 2016 Testing - Backward Comparability

Forum - Thu, 11/17/2016 - 16:00
I built an SSIS package using v 1.7 of the CozyRoc Zip Task, and deployed to a 2016 SQL Server, using Visual Studio 2015 with the SSIS Project Deployment Target set toSQL Server 2016. Everything worked fine. If I change the Deployment Target Parameter to SQL Server 2014 in the SSIS Project,
Categories: News
Syndicate content