Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS - Create multiple mdb output files dynamically Expand / Collapse
Author
Message
Posted Monday, July 06, 2009 3:33 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, January 22, 2014 10:29 AM
Points: 918, Visits: 486
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.txt OutputABC0101.mdb
BCD0101.txt OutputABC0101.mdb

CDE0101.txt OutputCDE0101.xls
DEF0101.txt OutputDEF0101.xls
EFG0101.txt OutputEFG0101.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..!!!


Post #747579
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse