Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
with NULLs in an SSIS Data Flow. In a Derived Column Transformation I have entered the following expression
0 0 0 0
but the pattern is still getting through.
[MSTUB-xInt_Only-Rev-Dt] == " 0 0 0 0" ? NULL(DT_WSTR,10) : SUBSTRING([MSTUB-xInt_Only-Rev-Dt],5,4) + "-" + SUBSTRING([MSTUB-xInt_Only-Rev-Dt],3,2) + "-" + SUBSTRING([MSTUB-xInt_Only-Rev-Dt],1,2)
|Convert Oracle SQL with Connect by prior to SQL Server SQL||6||31|
|Error "String or binary data would be truncated" in an update on a datatable||7||27|
|ORA-00923: FROM keyword not found where expected||3||21|
|Ssis not sending failure message||2||2|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!