DBA > Job Interview Questions > Microsoft SQL Server FAQs

Assuming the column name is correct, which of th

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

(Continued from previous question...)

Assuming the column name is correct, which of the following is a valid cast operation in SSIS _expression language?

Answer
(DT_STR, 20, 1252)[MyColumn]
Explanation
The correct answer is (DT_STR, 20, 1252)[MyColumn]. The cast uses parens and then the cast type specification with the _expression to be converted afterwards.

(Continued on next question...)

Other Job Interview Questions