SQL Server DB & SSIS Powershell Deployment

  •        0

A lightweight way to automate SQL Server builds and deploy SSIS packages to development environments. Uses Red Gate SQL Compare, SVN and Powershell. Ideal for DW/BI projects.




Related Projects

Scripted PowerShell Automated Deployment Engine (SPADE) for SQL Server

SPADE simplifies the process of standing up a new SQL Server instance by applying standard Operating System pre-configurations, Installing SQL Server and then applying post-configurations and creating standard objects.

SSIS ReportGeneratorTask

SSIS Task for SQL Server 2008 and 2012 to create server reports or local reports from a recordset data source.


PowerShell scripts for more object-oriented ETL than SSIS & remote SQL Server job initiation

SSIS command line package uploader

This goal of this project is to create a stronger command line deploy utility for SSIS packages destined for SQL server. Capabilities will include purging of existing content, creation and deployment to subfolders and uploads based off deployment manifest generated by Visual ...

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

SSIS GoogleAnalyticsSource

A SSIS Data Source Component for SQL Server 2008 and SQL Server 2012 to load data from the Google Data API.

Microsoft SQL Server Metadata-Driven ETL Management Studio (MDDE)

Originally an internal MSIT solution that has been released as an open source project, the Microsoft SQL Server Metadata-Driven ETL Management Studio (a.k.a. MDDE) provides a tool for rapidly generating SQL Server Integration Services (SSIS) packages from a shared central metadat

SQL Server Integration Services (SSIS) Application Server

SQL Server Integration Services (SSIS) Application Server is an application server built around managed Microsoft SqlServer.Runtime API designed to extend standard Integration services management and execution model.

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:http://sharpdevelop.net/OpenSource/SharpZi...

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.

SQL Deploy Anything

This project was created to create a standard tool to deploy anything to Microsoft SQL, SSIS packages, SQL scripts, and Database or SQL projects.

CopyLogins task

CopyLogins is a SSIS control flow task that can transfer logins from one SQL instance to another including the passwords for the SQL Logins

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.

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 Event Log Source

An SSIS 2005 Data Source component for loading Windows 2003/XP event logs (*.evt) into SQL Server 2005 for analysis

SQL Server PowerShell Extensions

The primary goal of SQL Server PowerShell Extensions (SQLPSX) is to provide intuitive functions around the SMO objects which are backward compatible with SQL 2000. A secondary goal is to provide an application which reports flatten/effective security settings.


An open source .NET web crawler written in C# using SQL 2005/2008. Arachnode.net is a complete and comprehensive .NET web crawler for downloading, indexing and storing Internet content including e-mail addresses, files, hyperlinks, images, and Web pages.

SSIS Custom Task BewiseSmartIndexManager

This project show an Maintenance Task which is availaible in Control Flow into SSIS Package.

Useful SharePoint Site Workflow Utilities

This project aims to make it easy use SharePoint 2010's Site Workflows as "event handlers" for various back end systems by providing ways to start site workflows on remote farms from SSIS, SQL CLR and any Soap Web Service Client.

SSIS Package Manager - PacMan

PacMan - The SQL Server Integration Services Package Manager is a utility designed to permit batch operations on arbitrary sets of SSIS packages. Users can select a single package, a Visual Studio project or solution or a file system folder tree and then validate or update all...