You want to script the execution of an Integrati

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

You want to script the execution of an Integration Services package from the command line for use from a Unix scheduler. What utility would you use?

Answer
dtexec.exe

Explanation
The dtexec.exe utility is used to configure and execute Integration Services packages from the command line.

(Continued on next question...)

Other Job Interview Questions

• When starting SQL Server 2005 from the command line, what does the -h switch do?
• You have a relatively new SQL Server 2005 and msdb is corrupt. How can you fix this database without a restore? (data loss is acceptable)
• You want to be sure that your Scalable Shared Database is as available as possible. Which of the following is not needed for this?
• What is a bookmark lookup?
• For regulatory reasons, you must maintain an exact text copy of your XML documents in your SQL Server 2005 database. What datatype of storage should you choose?
• Using Report Builder that is bundled with Reporting Services 2005, which of the following would work as a way to add a derived field to a report?
• What is the easiest way to capture the SQL statement for a Report Builder report you're troubleshooting?
• Which severity levels of errors can be corrected by a user (as opposed to those that an administrator or Microsoft must work to fix.)
• The queries still seem slow immediately after snapshot creation. Why?
• What is the best way to have your junior DBA do this?
• More...