SamplesV2/SQLServerIntegrationServices/publicpreview/CustomSetupScript/Sample/main.cmd (23 lines of code) (raw):
@echo off
xcopy /F /Y SleepTask.dll "%ProgramFiles%\Microsoft SQL Server\140\DTS\Tasks"
REM error handling
if %ERRORLEVEL% neq 0 (
echo Failed with ExitCode %ERRORLEVEL%
exit /b %ERRORLEVEL%)
echo "Complete copied to x64 folder"
xcopy /F /Y SleepTask.dll "%ProgramFiles(x86)%\Microsoft SQL Server\140\DTS\Tasks"
REM error handling
if %ERRORLEVEL% neq 0 (
echo Failed with ExitCode %ERRORLEVEL%
exit /b %ERRORLEVEL%)
echo "Complete copied to x86 folder"
gacutil\gacutil /i SleepTask.dll /f
REM error handling
if %ERRORLEVEL% neq 0 (
echo Failed with ExitCode %ERRORLEVEL%
exit /b %ERRORLEVEL%)
echo Successfully installed Sleep Task.
REM If you want to persist access credentials for file shares or Azure Files, use the commands below:
REM cmdkey /add:YourFileShareServerName /user:YourDomainName\YourUsername /pass:YourPassword
REM cmdkey /add:YourAzureStorageAccountName.file.core.windows.net /user:azure\YourAzureStorageAccountName /pass:YourAccessKey
REM You can then access \\YourFileShareServerName\YourFolderName or \\YourAzureStorageAccountName.file.core.windows.net\YourFolderName directly in your SSIS packages.