Hi I am a newbie to SSIS. I have to export an Excel file to SQL Server table but there is a column which has a certain format which need to be followed. Trying my luck to write its expression for Derived Column but in vain. The format is as follows:
0001 portion will be incremented depending upon the number of rows.
Thanks in advance.