Hi, Could anyone please take me through steps for creating a SSIS package which exports data from SQL Server 2005 table into an MDB file? The package should create the MDB file. I dont have any idea of MS access so please guide me accordingly or pointers to any page or site will also help. Thanks in Advance!! :) Thanks, Deepti Deepti

The Access-DB should exist or create a bat to do this. The bat you can execute with System Task. Or create the Access-DB via Script Task. In that case you can put the path and name of th enew createtd mdb into a SSIS-variable which you can use to set the Connection String dynamically. After that craete a Dataflow Task to extrct your data and paste them into a new table. I haven't done this before, but this will be the way I would try.