SSIS - Create multiple mdb output files dynamically

• HakunaMatata

  SSCrazy

  Points: 2610

  More actions

  July 6, 2009 at 3:33 am

  #135979

  Hi All,

  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.)

  eg.

  Input FIles:Output FIles:

  ABC0101.txtOutputABC0101.mdb

  BCD0101.txtOutputABC0101.mdb

  CDE0101.txtOutputCDE0101.xls

  DEF0101.txtOutputDEF0101.xls

  EFG0101.txtOutputEFG0101.xls

  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..!!!

  :rolleyes: