Hi Guys,
I am using Row Count Transformation, from row count I am getting 1,2,3,4....., however I want 00000001,00000002,00000003...... I got it in
derived column with this expression
New Derived Column = RIGHT("00000000" + (DT_WSTR,8) Row_Column,8)
My question is how I can use above expression in Microsoft Visual Basic 2008. I have total count value as in variable. For Example
My total count variable value is 148, I want to print on my header 00000148. I am using Script Task for footer in flat file in SSIS.
Any advise?