Skip to content

Instantly share code, notes, and snippets.

View gopishravs's full-sized avatar

gopishravs

1 follower · 0 following
View GitHub Profile
@gopishravs
gopishravs / DeploySSIS_ISPac.ps1
Created December 17, 2020 10:57 — forked from SQLvariant/DeploySSIS_ISPac.ps1
Deploy an .ISPAC file to a SSISDB Catalog using the SSIS Provider
# Variables
$TargetFolderName = "ProviderSolution"
$ProjectFilePath = "C:\temp\SSIS\TestSSISSolution\TestSSISProject\bin\Development\TestSSISProject.ispac"
$ProjectName = "TestSSISProject"
# Get the Integration Services catalog
$ProviderCatalog = Get-Item SQLSERVER:\SSIS\localhost\SQL2017\Catalogs\SSISDB\
# Create the target folder
New-Object "Microsoft.SqlServer.Management.IntegrationServices.CatalogFolder" ($ProviderCatalog,
@gopishravs
gopishravs / create git diff archive.md
Created November 4, 2020 03:00 — forked from adriancampos/create git diff archive.md
PowerShell script to export changed files between two commits

Usage:

.\createarchive.ps1

Creates an archive of the files that changed between HEAD and HEAD^

.\createarchive.ps1 e39eef

Creates an archive of the files that changed between e39eef and e39eef^

@gopishravs
gopishravs / Jenkinsfile
Created September 9, 2020 08:23 — forked from jonico/Jenkinsfile
Example for a full blown Jenkins pipeline script with multiple stages, kubernetes templates, shared volumes, input steps, injected credentials, heroku deploy, sonarqube and artifactory integration, Docker containers, multiple Git commit statuses, PR merge vs branch build detection, REST API calls to GitHub deployment API, stage timeouts, stage c…
#!groovy
import groovy.json.JsonOutput
import groovy.json.JsonSlurper
def label = "mypod-${UUID.randomUUID().toString()}"
podTemplate(label: label, yaml: """
spec:
containers:
- name: mvn
image: maven:3.3.9-jdk-8-alpine