You work as a database administrator at Abc.com. 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. PreviousNext
Suggest other answer Login to Discuss/suggest the answer...
You can help us to improve by giving your valuable suggestions at firstname.lastname@example.org
By using the service of this site, I agree that I will serve wholeheartedly
and will not indulge in any sort of activity that threats the integrity of the organisation I am working for / I work for.
I have a firm believe in the notion that knowledge should be open source and
helping the needy and deserving part of society will always be my motto.
Knowledge is the power, Dont miss any paper, Subscribe to us