Released CozyRoc SSIS+ 1.2 SR-1

Released CozyRoc SSIS+ 1.2 SR-1 (1.2.101.0). This release includes following major changes:

•   Implemented new action in the SFTP task for retrieving list of remote files.
•   Fixed Zip Task. It always created Zip64 archives, even when not needed.
•   Fixed Database Partitions Task:
  • Create Partition action failed with “Specified cast is not valid.” error message for certain partitioned tables.
  • Insert Partition action failed with “Cannot insert explicit value for identity column in table ‘…’ when IDENTITY_INSERT is set to OFF.” when partitioned table contained identity columns.

The SQL 2008 version is also updated.

Custom SSIS component events not working “by design”

Don’t waste time implementing custom data flow component events under SQL Server 2005. There is a bug, which prevents it from working. I just got back response from the SSIS PM the issue is acknowledged, but it will not be fixed in the foreseeable future for SQL Server 2005. To follow the status of this issue, track this report.