SSIS - Create multiple mdb output files dynamically

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » SSIS - Create multiple mdb output files...

SSIS - Create multiple mdb output files dynamically

Rate Topic

Display Mode

Topic Options

Author

Message

Sacheen

Posted Monday, July 06, 2009 3:33 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 5:19 AM
Points: 269, Visits: 343

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

Best Regards Smile

-
Sacheen

Post #747579

« Prev Topic | Next Topic »

Permissions