Can you explain the SQL Server Integration Services functionality in Management Studio?

 You have the ability to do the following:

  • Login to the SQL Server Integration Services instance
  • View the SSIS log
  • View the packages that are currently running on that instance
  • Browse the packages stored in MSDB or the file system
  • Import or export packages
  • Delete packages
  • Run packages

Comments

Popular posts from this blog

Difference between ETL vs. ELT

What are the for each loop enumerators available in SSIS?

What are the SSIS package protection levels?