I am trying to create a SSIS package where i have 2 txt files and be loaded into SQL.
txt file1 (10k records) txtfile 2(one record)
empid ename t1date t2date
I have the first text file with columns (empid,ename,t1date) with some 10k records and now i want this date column be replaced with date column of second text file(t2date). this second txt file contains only one record and one column. can I replace this one recrd with all 10k records?
I want to replace all these 10k records of t1date column with t2date record.
Hope am clear
Any suggestions is higly appreciated.