Tag Archives: powershell

Automate changes in SSIS packages

Posted on January 28, 2022 by erictummers

We use Sql Server Integration Services (SSIS) for importing and exporting data. The number of SSIS packages is stil growing and on writing this post we have 35 of them. Changing the database connectionstring for development means opening and editing … Continue reading →

Posted in Uncategorized | Tagged , , | Leave a comment

Parse IIS logs with powershell

Posted on December 24, 2021 by erictummers

With the log4j CVE we’re checking our IIS logs in detail. To automate this we’ve created a powershell script that parses the logs and provides query access. Below a script that searches for 502 responses and prints the fields we … Continue reading →

Posted in Uncategorized | Tagged | Leave a comment

Lift and shift SSIS package

Posted on October 15, 2020 by erictummers

We use Sql Server Integration Services (SSIS) to import text files into our database. The dtsx files are deployed into the MSDB on the Sql Server. Everything works well with deployment with a powershell DSC script. But times change and … Continue reading →

Posted in Development | Tagged , , , | Leave a comment

Webdeploy connectionstrings to xTokenize

Posted on July 10, 2020 by erictummers

We have an asp.net webapplication (full framework) and deploy it using release manager. The bits are in an artifact that is created during build with the contents of the webdeploy zip and a powershell desired state configuration (dsc) script to … Continue reading →

Posted in Uncategorized | Tagged , , , , , | Leave a comment

Update SEQ with Powershell DSC

Posted on February 17, 2020 by erictummers

We user Powershell Desired State Configuration (DSC) to install everything. A new installation could be done to a clean machine or by removing existing software prior to installing it. Below is part of the script we use. Now we want … Continue reading →

Posted in Development, Tooling | Tagged , , , | Leave a comment