I'm attempting to export data within SSMS 2008 into an Access database. The Access database must end up with table names that are different to the SQL database and maintain an Access 'text' data type on many of the fields.
Creating the export as an SSIS package:
It only enables me to drop and re-create the tables if I keep the original SQL table names from what I can gather. As soon as I change these I only have the delete & append options available to me.
The Varchar fields in the SQL database also get converted to memo fields (I need text fields) in the Access database which is about as much use as rubber lips on a woodpecker and I can't find a way around it.
Due to the above I assume I have to go down the delete and append route with my table names and data types already set in the Access database? Although this too is giving me problems (yet to dive into), am I correct with my conclusion so far or can you infact set the table names and an Access 'text' data type using drop and recreate?
Many thanks for your help peeps.