Hi..I am using sqlserver 2008

Hi..Actually are asked to validate this task without scripttask.We should use inbuilt transformations to achieve this task.Could you please tell me how can we acheive this.Just let me know the...

Thank you for the reply..

Basically i have Header and DetailRow table seperalty.So need to transfer H row to header table and D row to DetailRow.

Can i acheve this without...

Thanks for the reply..Just need to validate the filename CLM_20140504..Could you please let me know how can we validate.Today date is 20140504 so the CLM_20140504 is valid file.

File name...