SQL Server Premier Field Engineer Blog

How to use Partition Processing Destination Task to pump data into a SSAS partition via SSIS

To load and process the data into Analysis Services, SQL Integration Services provides two data flow components: Partition Processing Destination and Dimension Processing Destination . However, I found very few users know how to use them or use them correctly. 

What needs to be done to be able to edit DTS 2000 packages on a Windows 2008 or Vista Machine ?

This question has often been asked by customers who have a lot of DTS packages and want to continue running these packages on SQL 2008 servers running on Windows 2008 or Vista machines while they work on redesigning the packages to use the new features