SSIS: Topics

Topic 1:	What are the differences between DTS and SQL Server Integration Services(SSIS)?
Solution:	DTS is a set of objects using an ETS tool(tool to extracts, transforms, and loads information into a database for warehousing)in order to extract, transform, and load this information to and/or from a database, while SSIS is an ETL tool provided by Microsoft to extra data from different data sources.
See more...

Topic 2:	What are the configurations available in SSIS ?
Solution:	There are five ways in SSIS package to achieve the package configuration - XML configuration Environment variable Registry entry Parent package variable SQL server table
See more...

Topic 3:	Working with Precedence Constraints in SQL Server Integration Services.
Solution:	Precedence Constraints are useful to define workflow in a sequential manner for various Executables, Containers, tasks under Control tab as well as they also can be used to define the workflow in sequential manner in Event Handlers in SQL Server Integration Services. In simple words, Precedence Constraints are useful to perform the data transportation in a sequential manager based on certain business requirements.
See more...

Page - 1