Book a Presales Call

• Related Articles

• 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 ...

• 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.

• 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 ...