I want to create an SSIS package that will take txt files as input and XLS / MDB files as output.
(I want to load the data from txt files to mdb / xls files.)
Input FIles: Output FIles:
here in filename 0101 should be current date like here it is 1st Jan.
In mdb file, table name should be the same as output file name.
I want to create all output files dynamically.
Is there any solution to this?
Thanks in advance..!!!