Domanda di colloquio di Healthesystems
Name five SSIS tasks. Name three ways to execute an SSIS package. How do you account for errors in a package?
Risposta di colloquio
Anonimo
20 feb 2017
The 5 tasks mostly used are execute SQL task, data flow task, send mail task, file system task, execute process task And the ways to execute a SSIS package are: Using dtexec.exe , dtexecui and from the Ssdt application, sqlagent etc To access for errors we can see the log files and if it is SSIS 2012 and plus versions, in the integration services catalog the log information is saved.