SSIS Tools and Utilities

Monday, December 14, 2009

SSIS provides the following tools and utilities:
• Integration Services and Studio Environments= Describe how to use Business intelligence development studio and SQL server management studio with integration services.
•SSIS Designer = Graphical tool for building complex packages that include control flows, data flows, and event-driven logic.
•Integration Services Wizards= These wizards are for importing and exporting data, installing packages, migrating packages and creating package configurations.
•Command prompt utilities (SSIS) = For managing and running packages.
• Query Builder (SSIS)= Graphical tool for building queries.
• Expression Builder (SSIS) = Graphical tool for building expressions.

0 comments:

Post a Comment

 
 
 
Your Ad Here