I will be speaking at SQL Saturday #40, an all-day FREE SQL event taking place at Devry University on July 31st, 2010.
We will be making use of the INFORMATION_SCHEMA.COLUMNS to retrieve column properties for desired SQL Server tables then leveraging the ADOX Library to dynamically create corresponding Access database tables using C#. We will then continue to demonstrate how to Programmatically generate an SSIS package to copy selected rows from the SQL Server tables to their corresponding, dynamically-created, Access Tables. I hope for this talk to be a good forum for discussion where each of us learns something new.
To register and join the 400+ already-registered attendees, please visit www.sqlsaturday.com/40/eventhome.aspx
Looking forward to meeting you all there.
-Sam Abraham