We’ve released a minor update to SQLPSX which includes includes several bug fixes/enhancements as well as one new module. Here’s an excerpt from the release notes: Added MySQLLib Module Mike Shepard created a MySQL module for querying MySQL databases. This is similar in concept to the adolib and OracleClient modules. Modified adolib Module Changed SQLBulkCopy…
Tag Archive: SSIS
T-SQL Tuesday #15 Automation and the SSIS Dumper
This post is my contribution to T-SQL Tuesday, hosted this month by Pat Wright (blog | twitter). In my previous post Importing and Exporting SSIS Packages Using PowerShell I showed you how to import/export SSIS stored in MSDB to and from the file system. In this post we’ll look at exporting all SSIS packages from…
Importing and Exporting SSIS Packages Using PowerShell
SQL Server PowerShell Extensions (SQLPSX) includes a set of function for working with SSIS which among other things allow you to import and export SSIS packages between the file system and msdb. The functionality is best illustrated by looking a few examples. Creating an SSIS folder Note: The SSIS module supports SQL 2005 through 2008…
T-SQL Tuesday #005: SSIS Reporting
Automating SQL Server Integration Services (SSIS) administration through PowerShell is very different than writing scripts against the core database engine. Once you move outside the core database engine the .NET classes for working with SQL Server features like SQL Server Integration Services vary greatly in the way they are implemented. The core database engine has…
Adventures in Powershell SSIS Administration Programming
In January 2009, I released version 1.4 of SQL Server Powershell Extensions which included a Library of functions for working with SQL Server Integration Services (SSIS). This post describes the functionality included in the script library including enumerating msdb package stores, getting packages from msdb and file stores as well as copying packages and folders among…
Execute SQL Server Integration Services (SSIS) Package from Powershell
***Updated 2/23/2009. After some additional testing I discovered you cannot change the location of SSISConfig without saving and reloading a package or exporting and importing a configuration, so I removed the functionality to reset the config location since there isn’t an easy way of doing so. In addition errors were not being automatically enumerated. The…
