FAQ
While using a mapping variable for Dynamic Data Flow in Data Flow Task Plus, how can I block data from moving from source table to destination unless specifically mapped.
If you don’t want a source column to be mapped to a destination column, you have to provide empty source column mapping, like the following : ClientKey= VendorKey= Last Updated: 4/17/2024
How can I dynamically modify a transformation in an SSIS Data Flow Task?
COZYROC's Data Flow Task Plus allows you to dynamically modify source, destination and transformation components at runtime. For an overview and listing of properties for the following transformations, please check out the side menu item "Parameters" ...
What is the End of Life (EOL) schedule for each major version.
A previous major version is supported for THREE YEARS after the release of the next major version. The support for 1.6 version ends January 5th, 2020. The support for 1.7 version ends May 3rd, 2021. The support for 1.8 version ends July 1st, 2022. ...
Does COZYROC support TLS 1.1 and 1.2 protocols?
The following COZYROC connections now support TLS 1.1 and TLS 1.2. IMAP Connection Manager TLS 1.1 and TLS 1.2 support became available for use in IMAP Connection in SSIS+ 1.6 SR-4. TLS 1.3 support became available for use in SSIS+ 2.0. POP3 ...
Where can I find the release notes for COZYROC SSIS+?
The release notes for SSIS+ can be found on the main COZYROC website at www.cozyroc.com under the "Support" menu item. You can click this link, "Release Notes", to be taken to that page now. The release notes for development builds can be found at ...
Where can I find the documentation for the Data Flow Task Plus?
You can find documentation related to all the COZYROC SSIS+ Suite tasks from the main products page. Specific documentation for the Data Flow Task Plus can be found at the following link. For many of the tasks and components, you can find an ...
Can I enable a property to be set dynamically from variable using an SSIS Expression?
When using Data Flow Task Plus, sometimes you want to be able to set parameters in the source, transformation or destination components within the data flow, but those parameters are not available by default. Let's take a look at an example. In this ...
Data Flow Task Plus editor doesn't open
When I double-click on Data Flow Task Plus, the Data Flow Task Plus Editor doesn't open and instead of that I am sent to the Data Flow tab. There is a known issue in Visual Studio when a solution file is opened externally (e.g. from the taskbar ...
Dynamic Flat File Import uses wrong THUNK_COLUMN length.
Issue: It appears that the column length is being picked up from whatever we set the THUNK_COLUMN length against the Flat File Connection manager rather than the destination table individual column length's. Solution: Set the THUNK_COLUMN column type ...
How to build the data flow setup
The initialization and user interface for a data flow is defined by implementing properties on the script EntryPoint class. The documentation and samples of Script Task Plus for defining parameters is relevant to the Data Flow Task Plus ...
DataFlowSetting .NET attribute used with Data Flow Task Plus
The DataFlowSetting .NET attribute defines a list of references to different component properties in the SSIS data flow. It defines the link between the initialization parameter and a specific SSIS data flow component parameter. You can apply one ...
Dynamic Data Flow - How to create completely dynamic data flow?
Starting from 1.4 SR-3 the data flow can be completely dynamic - the need to have one common column across different iteration sets is no longer required. To have completely dynamic components, you have to remove all statically defined columns (both ...
Dynamic Data Flow - Dynamic Column Custom Handler
To setup custom routine in the data flow script for additional setup of dynamically added data flow column, attribute your script main class with DataFlowColumnAdded attribute. Set as parameter the name of the script method. Check below the required ...
How to increase the Data Flow Task Plus buffer size?
To increase the Data Flow Task buffer size please complete the following steps: 1) Right-click on the Data Flow Task and select Properties. 2) On the Data Flow Task's Properties screen under Misc find fields: DefaultBufferSize and ...
Dynamic Data Flow - "... is DT_NTEXT, which is not supported with ANSI files" when trying to process input Unicode flat file
Trying to process input Unicode flat file fails with weird error: The data type for "Flat File Source.Outputs[Flat File Source Error Output].Columns[Flat File Source Error Output Column]" is DT_NTEXT, which is not supported with ANSI files. Use ...
Error Message: "Could not load file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependenciesâ€
Action: While using the OLE DB Destination inside of Data Flow Task Plus, the following error is encountered. Error Message: “Could not load file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of ...
Warning Message: No Dynamic Columns
Action: When I am executing a package that includes a Data Flow Task Plus Component I get the following warning message: Warning Message: No Dynamic Columns Solution: This warning message might be a sign that you haven't configured the package ...
Error Message: Flexible File Source failed validation and returned validation status VS_NEEDSNEWMETADATA
Action: While executing a package that uses Azure Flexible File Source in a Data Flow Task Plus, the following error message is received. Error Message: '"Flexible File Source" failed validation and returned validation status "VS_NEEDSNEWMETADATA"' ...
Error Message: The ODBC Source.Outputs[ODBC Source Output].Columns[THUNK_COLUMN] has an invalid error or truncation row disposition.
Action: When executing a package using Data Flow Task Plus withing a Foreach Loop and an ODBC Source, the first iteration of the loop succeeds, followed by the following error message on the second iteration of the loop. Error Message: 'The ODBC ...
Error Message: fixed queue overflow
Action: While uploading a higher number of records to a REST Destination component within a Data Flow Task, the following error message is received. Error Message: “fixed queue overflow†. Solution: This error is related to the value established ...
Error Message: The Flat File Source.Outputs[Flat File Source Output].Columns[THUNK_COLUMN] has an invalid error or truncation row disposition.
Action: When executing a package using Data Flow Task Plus within a Foreach Loop and a Flat File Source, the first iteration of the loop succeeds, followed by the following error message on the second iteration of the loop. Error Message: ''The Flat ...
What are the advantages of using the COZYROC Database Partitions task?
Although the partitioning support in SQL Server 2005 is powerful, many find it difficult to use since Microsoft has not provided an easy-to-use point-and-click interface. The COZYROC Database Partitions task makes the process of implementing ...
Does the Database Partitions task support transactions?
Yes, it does. The task is using the connection object provided by the connection manager (AcquireConnection). It doesn't instantiate a new connection object based on a connection string. We went through all this hassle to make sure we DO support ...
Can the Database Partitions task convert an existing table into a partitioned table?
No. To create a table, define your partitioning function and schema and create a table based on it. The task will assist you by manipulating needed partitioning ranges and switching in/out partitions and data. Last Updated: 4/17/2024
Can you describe what the 'Combine Partitions' action does?
We will explain this action by describing a typical scenario in a data warehouse implementation. We are talking, in particular, about an SSIS workflow which processes data every day. In such a case, you usually have your table partitioned by date. ...
Why doesn't the Database Partitions task support the ODBC connection manager?
Unfortunately, the current incarnation of SSIS 2005 has incomplete connections support. ODBC is one of these connections. The workaround doesn't work because the connection returned by the manager is not of type OdbcConnection. We are working on ...
Where can I find the documentation for the Database Partitions Task?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Database Partitions Task can be found at the following link. For many of the components you can find ...
Where can I find the documentation for the File Transfer Task?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the File Transfer Task can be found at the following link. For many of the components you can find ...
How to resolve File Transfer Task failing when no files exist.
This KB article is not relevant if you are using "Get Remote Files List" action on File Transfer Task. Instead, you can use this COZYROC prepared Javascript: https://www.cozyroc.com/ssis/script-ftp-file-exists-task If you are not sure there will be ...
Can I use the Flat File Connection Manager with the File Transfer Task?
The Flat File Connection Manager can be used with the File Transfer Task for the Local parameter when the Action is Send Files. However, it cannot be used when the Action is Receive Files. In that case, a File Connection Manager should be used. If ...
How to get to the root directory on a remote server
When getting the list of files from a remote server using the “Get remote files list†action with the File Transfer Task, you may need to use a special escape character sequence to get to the root of the remote directory. The typical characters ...
Requirement for successful data streaming
If you use this task to stream data, set the RetainSameConnection parameter to TRUE on the connection manager. Otherwise, the connection will be closed before all the data is transferred. Last Updated: 4/17/2024
How can I move files on the remote server?
Files on a remote server may be moved by using the Rename remote files Action. Simply include the name of the directory where you want to move the file(s) in the path using the NewName parameter. Last Updated: 4/17/2024
What format should I use for the time and date in the LocalFilter parameter of the File Transfer Task?
Use a FLEE expression. The syntax for the time is: ModifiedTime >= #06/29/2023# + ##09.00:00# Last Updated: 4/17/2024
What is the proper date/time format for the RemoteFilter parameter on the File Transfer Task?
If you want to use a filter for the remote files that includes both the date and the time, use the following format: TimeSpan - A string in the format ##[d.]hh:mm[:ss[.ff]]#. Example: #08/06/2008# + ##1.23:45# Last Updated: 4/17/2024
Is there a predefined component for the SFTP service "BrickFTP" (REST API)?
Support for the BrickFTP service is provided by COZYROC's File Transfer Task used with the FTPS Connection Manager. Set the Connection Type to "ExplicitTLS" and the Port to "21" in the connection manager. Last Updated: 4/17/2024
How can I turn on verbose logging for the File Transfer Task or the SFTP Task?
To turn on verbose logging in the SSH connection manager, open the Advanced tab can click on the checkbox next to "Verbose log" and make sure "Use binary transfer" is also selected. ​ Last Updated: 4/17/2024
FLEE Expressions for filtering
FLEE expressions are used to define criteria for filter parameters in several COZYROC tasks and components. FLEE is a “Fast, Lightweight Expression Evaluator.†Finding documentation to help you configure a valid expression can be challenging. The ...
How to structure a package using File Transfer Task to Send Files that match my criteria from several local sub-folders
This video demonstrates how to configure a package, using the File Transfer Task, so that it only sends local files to the remote server if they match specified criteria . Several local folders must be scanned to find the files that should be sent. ...
How can I move files between folders on the SFTP Remote Server?
Files on a remote SFTP server may be moved by using the Rename remote files Action in the File Transfer Task component. You should just include the name of the directory where you want to move the file(s) in the path using the NewName parameter. When ...
Next page