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. Every time you run the SSIS process, it creates a new partition for the new date. By the end of the week you will have 7 partitions. By the end of the month (for a 30-day month) you will have 30 partitions. For a whole year, you will have more than 360 partitions.
With such an arrangement, you will easily end up with hundreds of partitions to manage. This is where the 'Combine Partitions' action comes in handy. It will let you control the granularity of the partitions. For example, you could combine partitions so that you end up with one partition per week of data or one partition per month of data. This will also make rolling-off and backing up your old data easier.
Book a Presales Call
Related Articles
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 ...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 ...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.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 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. ...