Video: SQL Server Integration Services on Linux

THE VIDEO

THE SYNOPSIS

In this video, we bang our heads against the wall repeatedly with respect to SQL Server Integration Services. I spend a lot more time than I want to but we do get a mostly-functional product mostly working.

THE COMMANDS

Following are the command line operations I used throughout the video.

sudo apt-get install -y mssql-server-is


sudo /opt/ssis/bin/ssis-conf setup


sudo apt-get install -y vim
vi .bashrc
# Add this to the bottom of .bashrc:
export PATH=/opt/ssis/bin:$PATH

source ~/.bashrc
echo $PATH


sudo apt-get -y install openssh-server


cd ~
mkdir ssis


# NOTE: change IP address to your IP or server name
ssh testo@172.20.148.159


# The following should run in Windows, assuming this is where your SSIS project was.
D:
cd D:\SourceCode\Simple SSIS Project\Simple SSIS Project
scp .\Package.dtsx testo@172.20.148.159:/home/testo/ssis/


# Run the following on the Linux machine
cd ~/ssis
dtexec /F Package.dtsx /DE SSISPackage


dtexec /F Package.dtsx /DE SSISPackage | tee Package_log.txt
less Package_log.txt


# Run the following on Windows:
scp .\BadPackage.dtsx testo@172.20.148.159:/home/testo/ssis/


#Run the following on Linux:
dtexec /F BadPackage.dtsx /DE SSISPackage


vi DailyETL.sh
# The following is the contents of DailyETL.sh:
/opt/ssis/bin/dtexec /F /home/testo/ssis/Package.dtsx /DE SSISPackage >> /home/testo/ssis/cron_output.txt 2>& 1


chmod +x DailyETL.sh
crontab -e
# The following is what you'd add to the crontab file. Use the correct time!
17 8 * * * /home/testo/ssis/DailyETL.sh 2>&1 | logger -t DailyETL


grep DailyETL /var/log/syslog

LINKS AND ADDITIONAL INFORMATION

All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems all across the data platform space.

• Install SQL Server Integration Services on Linux
• Configure SQL Server Integration Services on Linux with ssis-conf
• Schedule SQL Server Integration Services package execution on Linux with cron
• Limitations and known issues for SSIS on Linux
• Release Notes for SQL Server 2022 on Linux
• SQL Server Data Tools for Visual Studio 2022
• Outlier detection artificially generated bus data
• Using the SSMS WMI Task to Gather System Information
• “(CRON) info (No MTA installed, discarding output” error in the syslog