Microsoft Download Center Archive

SSIS Database Sharding and Azure Blob Storage components

  • Published:
  • Version: 1
  • Category: Tool
  • Language: English

The Sharding Catalog Setup Scripts contain scripts to setup the schema needed for the Sharding Catalog for the Database Sharding Destination.

  • The Sharding Catalog Setup Scripts contain scripts to setup the schema needed for the Sharding Catalog for the Database Sharding Destination. It also contains examples of how to use the stored procedures to develop a sharding catalog. This sharding catalog will contain the details on how to shard a destination data set, and can be used in conjunction with the Database Sharding Destination to create a dynamic sharded destination for SSIS packages which must send data to sharded ADO.NET destinations such as Windows Azure SQL Database, or Microsoft SQL Server.

Files

Status: Live

This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

FileSize
Sharding Catalog Setup Scripts.zip
SHA1: 878206290630eae4129440948af45507aab89e9d
5 KB
SSIS Database Sharding Components.zip
SHA1: 8f08ca672d2f0f611d1709a2834d435500ca8376
2.05 MB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

System Requirements

Operating Systems: Windows 7, Windows 8, Windows Server 2008 R2 SP1, Windows Server 2008 Service Pack 2, Windows Server 2012, Windows Vista Service Pack 2

  • SQL Server 2012

Installation Instructions

  • The SSISDatabaseSharding64.MSI file installs four components onto a machine with Microsoft SQL Server 2012 with the SSIS components installed. • Database Sharding Destination • Database Sharding Destination Connection manager • Blob Storage Destination • Blob Storage Source Once installed, these components will appear in the list of available components in the SSIS Development Tools, and will be usable for design and execution in SSIS.