Manage SSAS Partitions with SSIS Script Task

  •        0

Manage SSAS Partitions using the SSIS Script Task. Awesome!



Related Projects


SSAS AMO DB is a database version of AMO which helps to view the metadata stored in the SSAS cube. The Metadata will be loaded into a SQL Server database from the SSAS cube using AMO using SSIS package. From that database user can generate reports for the SSAS metadata. A da...

SSAS Operations Templates

SSAS Operations Templates includes SSIS packages, scripts and code samples for automating maintenance of SSAS in a production environment. Includes operations such as backup the current state of cube designs in production, scripting paritition creation, etc.

BIDS Helper

A Visual Studio add-in with features that extend and enhance business intelligence development functionality in SQL Server 2005, 2008, and 2008 R2 BI Development Studio (BIDS) and SQL Server 2012 SQL Server Data Tools (SSDT).

SSAS Profiler Trace Collector with Scheduling Facility

AS Profiler Scheduler is a tool that will enable Scheduling of SQL AS Tracing using predefined Profiler Templates. For tracking different issues there are different templates.

SSAS Entity Framework Provider community FAQ and online support documentation

This project is for SSAS Entity Framework Provider community FAQ and other community online support documentation (see Documentation tab > FAQ). SSAS Entity Framework Provider enables you to use LINQ and Microsoft ADO.NET Entity Framework to query SQL Server Analysis Servic...

SSAS Query Log Decoder & Analyzer

The Crisp description for the project will be "CUBE FOR CUBE". This is an end-to-end BI solution for analyzing the Query log created by SSAS Server. The Query Log data is loaded into a dimensional model and a cube is built on top of it for analysis of cube usage.

Drilltrough and filtering on SSAS-cubes in SSRS

We will describe a technique to create Reporting services (SSRS) reports that use Analysis services (SSAS) cubes as data sources, have a very intuitive interface and take full advantage of SSAS performance optimization features.

SSIS Twitter Suite

The SSIS Twitter Suite contains custom SSIS objects that call the Twitter REST API. All classes are in VB.NET. This project allows you to use Twitter in your SSIS package or as a template to create your own custom objects with different functionality!

SSIS Event Log Business Intelligence

The SSIS Event Log Business Intelligence package is a complete BI project focused around SSIS Event Log data. Components include: - 9 SSRS Reports - ETL Data Mart - SSIS packages to load ETL Data Mart - Analysis Services Cube - PerformancePoint Dashboard

PowerShell Script Task for SSIS

To produce a control flow task for SSIS that can be used to run PowerShell scripts within SSIS. It should integrate SSIS and PowerShell so that SSIS specific information (i,e. variables) can be accessed etc from within your script. The initial versionn has the following feat...

ETL Framework

This ETL Framework supports dynamic configurations and centralized logging for SSIS solutions in support of minimizing ETL TCO. It consists of an ETL Framework database, SSRS reports and template SSIS packages.

SSIS - Oracle Destination via ODP.Net (Custom Destination Component)

SSIS 2008 R2 solution (custom destination component) to write to oracle via ODP.Net

SSIS Reporting Pack

* SSRS reports that operate over the SSIS catalog * A stored proc, sp_ssiscatalog, that provides detailed analysis of the SSIS Catalog


GDAL SSIS is a collection of geospatial components for SQL Server Integration Services (SSIS) that leverages GDAL to support a large number of GIS data formats.

TaskUnZip for SSIS

Simple Task for SSIS (SQL Server Integration Services) for manage compress file ZIP. This task (Control Flow Items), permit compress/decompress file zip in SSIS Task context. Support password. _Work in Progress!_ ;-) Tnx to: *[url:

Dynamic Data System - ETL for SQL Server using dynamic SSIS

DDS makes loading a data warehouse much easier and faster. This system uses SSIS to load standard and partitioned tables via SSIS packages created on the fly using metadata. No longer will you have to maintain complex SSIS packages. Only basic T-SQL skills are needed. Pr...

SSIS Expression Editor & Tester

An expression editing and testing tool for SQL Server Integration Services (SSIS). It also offers a reusable editor control for custom tasks or other utilities.

SSIS Multiple Hash

SSIS Multiple Hash makes it possible to generate many Hash values from each input row. Hash's supported include MD5 and SHA1.

SSIS Control Flow Task Components

This page will presets you a brief introduction of some SSIS Custom Components that can help you in your SSIS developements.