I am importing some tables from a MS Access to SQL server 2005 and I am using the import wizard but I am not seeing the data mapping tool, I need to have the ability to delete the data from the destination server and allow the identity. I had done many times in the past, but I just got a new computer and I installed the SQL server 2005 workstation in it. Is a setting that I need to change? that will allow me to have the data mapping. Thanks a lot Angie

Hi Angie, This is SQL Server reporting services forum. However, i still try to answer your question. In my opinion, i would recommand you use SSIS to import the table data into SQL Server instead of Import and Export tool. The SSIS provides more functionalities including data mapping when ETL. Hope this helpfully, thanks, Jerry