Mr. Darekar’ s client uses SQL server 2008. But now his client has bought a new Server machine with new Hardware configuration and has got SQL server 2012 installed on it. Client has decided to discontinue with SQL server 2008 but wants to use existing databases in new SQL Server 2012. So Mr. Darekar has been asked to move all existing databases available on SQL Server 2008 to SQL server 2012. Which Task/Transformation in SSIS will be the best option to do the same?

To get all Infosys Certified Microsoft SSIS Advanced Developer Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee