I hope that this is the correct forum for this question. I have been tasked to Copy a SQL Database out to 60 Access databases one for each of the entitiies that use the SQL DB. Each of the entities will gety all common data and only the entitie specific data for that entity. this will be done daily. This strikes me as an SSIS task but do I need to create an Access template first then write tasks for each table imported? No even sure where to begin. Thanks Mike

"Well begun is half done!" -- Mary Poppins Sorry, I couldn't resist. Yes you have come to the right pace. 60 Access Databases, eh? Sounds like a job for a For Each loop. But before you do that, design ONE SSIS package to export ONE set of data to ONE Access database. Start maybe with a Template mdb or accdb file, depending on the Access version, an use a File System Task to copy that template to a new location and give it an appropriate name for the Client. Then design the data flows to populate the Access tables from the SQL Data, and can we assume that you can write a parameterized stored procedure(s) to extract the data for only ONE client? Once you have all that working, build a Client list and use an Execute SQL Task to query it and set its Result Set to Full Result, and send it to a Variable of type Object. Then there would be the For Each loop set to enumerate over and ADO object (the variable) and send values to variables. Move all your Client Specific stuff into the For Each Loop and configure, using Expressions, the connection managers, etc based on variables mapped from the For Each loop. Post back here if you have specific questions on putting all the pieces together.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

Thanks I'll be starting it in the next day or so.