Explanation:With SSIS wizards,we can create a structure on how the data flow should happen and make a package and deploy it based on our needs to execute in any environment. 2. Point out the wrong statement :
A. Prior to SSIS, Data Transformation Services (DTS) in SQL Server 2000 performs the tasks with fewer features
B. SSIS is used to perform operations like loading the data based on the need, performing different transformations on the data like doing calculations
C. Business Intelligence Development Studio (BIDS) is a tool which can be used to develop only SSIS packages
D. All of the mentioned
Answer:A
Explanation:With SSIS wizards,we can create a structure on how the data flow should happen and make a package and deploy it based on our needs to execute in any environment. 2. Point out the wrong statement :
A. Prior to SSIS, Data Transformation Services (DTS) in SQL Server 2000 performs the tasks with fewer features B. SSIS is used to perform operations like loading the data based on the need, performing different transformations on the data like doing calculations C. Business Intelligence Development Studio (BIDS) is a tool which can be used to develop only SSIS packages D. All of the mentioned
Explanation: BIDS is available with SQL Server as an interface which provides the developers to work on the work flow of the process that can be made step by step. 3. Which of the following is the best practice related to SSIS ?