bjh1977

pool:
  vmImage: windows-latest

variables:
  - template: vars-all.yml
  - template: vars-dev.yml

steps:
# Use default for variable value (look for "$(..)"), but only for variable name "resourcename", and only warn
- task: validateVariablesTask@0

bjh1977

variables:
  environmentname: dev
  resourcename: $(name)-$(locationshort)-$(environmentname)
  

bjh1977

variables:
  name: resource1
  location: northeurope
  

bjh1977

variables:
  - group: my-var-group

bjh1977

variables:
  myvar1: thisvalue

bjh1977

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

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

# 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

#
# 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

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

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