SSIS’s primary functions are data integration & workflow activities. SQL Server integration services extract the requested…