>>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?
It is SQL Server 2008 and I don't know how to tell if SSIS is installed or not.
Timothy Bryan