Browse by Tags

• Powershell Workflow
• sql server
• sql server integration services

• Parallel Foreach loops, one reason to use Powershell Workflow instead of SSIS

  Lately I’ve been using Azure Automation which is a service on Azure for running Powershell Workflow scripts, as such as I’ve diving deep into Powershell Workflow. What’s Powershell Workflow? I’m glad you asked: A workflow is a sequence of programmed, Read More... Posted Tuesday, December 9, 2014 4:59 PM by jamiet | 9 Comments Filed under: ssis, Powershell, Powershell Workflow

• Export all SSIS packages from msdb using Powershell

  Have you ever wanted to dump all the SSIS packages stored in msdb out to files? Of course you have, who wouldn’t? Right? Well, at least one person does because this was the subject of a thread ( save all ssis packages to file ) on the SSIS forum earlier Read More... Posted Wednesday, February 2, 2011 8:45 AM by jamiet | 19 Comments Filed under: sql server, sql server integration services, ssis, Powershell