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?
Timothy Bryan