get the app get the app       get the app       get the app

Question: You work as a database administrator at You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package. The SSIS package gets data from a FTP server by using numerous FTP tasks. The package also manages data using various Execute SQL tasks. You need to make sure that the package is set to restart after the package downloaded the files. What should you do?
1)You should consider configuring the HTTP tasks to hold transactions Log.
2)You should consider configuring the a store procedure to hold transactions Log.
3)You should consider transferring the half HTTP job to a sequence container.
4)You should consider configuring the package to use a checkpoint.

Previous Next

Suggest other answer
Login to Discuss/suggest the answer...

Exam Exam: 70-448 MS SQL Server 2008, Business Intelligence

Recommended Learning for you

Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material