>Hello all,
>
>I need to import a badly designed Access database into SQL server so I can manipulate and re-organize the data programatically in order to export it to csv files. I go through the import wizard and set up the data mappings basically just straight across but it keeps failing. Then when I try to save the dtsx file I am not able to open it again. I am getting a message; see attached.
>
>Question 1: Are there data mappings that should be altered for access data to come over properly?
>
>Question 2: How can I create this import and save it to run again later?
What is your SQL Server version and do you have SSIS installed?
If it's not broken, fix it until it is.
My Blog