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

• In SSIS, what is the difference between output columns and external columns?
• In replication, what is each set of the source data that is replicated from the source server called?
• You are using SQL Server 2005 and you wish to find a number of details about stored procedures created...
• What could be the problem if you know the service is working properly?
• How many dimensions can you have in a SQL Server 2005 Analysis Services database?
• You wish to initialize subscribers to your SQL Server 2005 database using FTP. Which versions can you do this with?
• To which versions of SQL Server 2005 can you upgrade an SQL Server 2000 MSDE SP3 edition database?
• Credentials in SQL Server 2005 are used to access what?
• What does a return value of -1 mean from the function XACT_STATE() in SQL Server 2005?
• You have a Scalable Shared Database setup for reporting purposes on SQL2. You want to be able to keep a point in time view of the reporting database each month. What can you do?
• More...