Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags powershell, Integration Services (SSIS) Rss

   Items 1 to 5 of 5   
 

SSIS 2012 - Using PowerShell to Remotely Execute File System Packages in Multi-Server Scenarios

In this article Marcin Policht discusses different methods of executing SQL Server 2012 Integration Services packages deployed by employing the traditional Package Deployment Model, focusing in particular on those stored in the .dtsx file system format.   Read more...
By Additional Articles 2013/08/27 | Source: Database Journal | Category: file system task
Rating: (not yet rated)  Rate this |   Briefcase | 1,870 reads

SSIS 2012 - Using PowerShell to Remotely Execute File System Packages

A Powershell script that allows you to execute SSIS packages using the traditional Package Deployment Model can be very useful. But what do you do when the execution isn't triggered by the same computer where the target package resides? Marcin Policht offers a solution.  Read more...
Rating:  Rate this |   Briefcase | 2,144 reads

SQL Server 2012 Integration Services - Using PowerShell to Configure Project Environments

Continuing our discussion on how to leverage the capabilities of PowerShell to automate the most basic SSIS management tasks, this article will explore more complex topics by demonstrating the use of PowerShell in implementing and utilizing project environments.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,574 reads

SQL Server 2012 Integration Services - Introduction to Managing SQL Server with PowerShell

Marcin Policht presents the fundamental principles of PowerShell in the context of SQL Server 2012. Join him as he steps through its initial setup and configuration, and reviews specific management areas where its advantages can be realized.  Read more...
By Additional Articles 2013/01/31 | Source: Database Journal | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 2,812 reads

Powershell - Modify Server Name in SQL 2005 SSIS Connections

This powershell script updates the server name specified in connections within a SQL 2005 SSIS package  Read more...
By Mandeep Dulai 2011/06/24 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 589 reads
   Items 1 to 5 of 5   
 
Tags