SQLTeam.com | Weblogs | Forums

SSIS Packages

What is the advantages/disadvantages installing SSIS Packages in a remote server considering the host server is a busy server?

SSIS packages will be effective if using it with ssis data flow components. It allows you to integrate database and cloud data via SQL Server Integration Services (SSIS)