bjh1977

 param (
    [string]$Version = $( Read-Host "Input version" ),
    [string]$DomainName = $( Read-Host "Input domain name" ),
    [string]$ApplicationName = $( Read-Host "Input application name" )
 )


$ApplicationURI = $("https://$DomainName/$ApplicationName")

bjh1977

$InstallDir = join-path $env:temp 'Nuget'

if (Test-Path $InstallDir) {
    Remove-Item -Path $InstallDir -Recurse -Force 
}

New-Item -Path $InstallDir -ItemType Directory -Force | Out-Null

# grab nuget commandline from internet

bjh1977

function Install-NugetFromNugetOrg {
    <#
       .Synopsis
       Gets nuget from nuget.org
       .Description
       Gets nuget from nuget.org. Either the latest or a sprecific version
       .Parameter RequiredVersion
       The version as seen on www.nuget.org
       .Parameter RootFolder
       The root folder where nuget will be copied to

bjh1977

Function Install-ADAuthenticationLibraryforSQLServer {
    
    $workingFolder = Join-Path $env:temp ([System.IO.Path]::GetRandomFileName())
    New-Item -ItemType Directory -Force -Path $workingFolder
    
 
    $fileName = 'adalsql.msi'
    $Installer = Join-Path -Path $WorkingFolder -ChildPath $fileName

bjh1977

$path = "\\path\to\file\msoidcli_64bit.msi"

$comObjWI = New-Object -ComObject WindowsInstaller.Installer
$MSIDatabase = $comObjWI.GetType().InvokeMember("OpenDatabase","InvokeMethod",$Null,$comObjWI,@($Path,0))
$Query = "SELECT Value FROM Property WHERE Property = 'ProductCode'"
$View = $MSIDatabase.GetType().InvokeMember("OpenView","InvokeMethod",$null,$MSIDatabase,($Query))
$View.GetType().InvokeMember("Execute", "InvokeMethod", $null, $View, $null)
$Record = $View.GetType().InvokeMember("Fetch","InvokeMethod",$null,$View,$null)

bjh1977

[uri] $BlobURI = New-AzureStorageBlobSASToken -Context $context -CloudBlob $blob.ICloudBlob -Permission r -ExpiryTime $ExpiryTime -FullUri

New-AzureRmAutomationModule -Name $ModuleName -ResourceGroupName $AutomationResourceGroupName -AutomationAccountName $AutomationAccountName -ContentLink $BlobUri

bjh1977

#
# More info here: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-directory-file-acl-powershell
#
Login-AzAccount

$ResourceGroupName = '<RESOURCE GROUP NAME>'
$StorageAccountName = '<STORAGE ACCOUNT NAME>'
$filesystemName = 'cont1'
$dirpath = "folderx/y/z1/"

bjh1977

# Point this at your SSIS project directory:
$SearchFolder = 'C:\Users\Joe.Bloggs\source\repos\SSIS_Test1\SSIS_Test1'

$Results = @()

Get-ChildItem $SearchFolder -Filter '*.dtsx' | ForEach-Object {

    $FileContent = Get-Content $_.FullName -raw
    $FileName    = $_.BaseName
    

bjh1977

{
  "$schema": "https://schema.management.azure.com/schemas/2015-01-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "emailActionGroupName": {
      "type": "string",
      "metadata": {
        "description": "Unique name (within the Resource Group) for the email Action group."
      }
    },

bjh1977

variables:
  - template: azure-pipelines-vars.yml