Update DataTransfer load script

Update DataTransfer load script.ps1

# Update DataTransfer load script

# Location of datasets.json file
$ds_path = "C:\ProgramData\Qlik\DataTransfer\DataUpload\storage\datasets.json"

# Get file contents as PSObject
$ds = Get-Content $ds_path | ConvertFrom-Json -Depth 20

# Narrow to relevant data connection
$aws_con = $ds | ? { $_.name -eq "AWS SQL Server test 1" }

# Update load statement
# $aws_con.loadStatement = '[student demographics]: SELECT "Student_ID" FROM SampleDB.dbo."student demographics";'
$aws_con.loadStatement = (Get-Content "C:\Users\Administrator\Desktop\new_load.sql" -Raw).ToString()

# Update datasets.json
$ds | ConvertTo-Json -Depth 20 | Set-Content $ds_path

# Restart the DataTransfer service
Get-Service -Name "*DataTransfer*" | Restart-Service