>>>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.

Which edition of SQL Server?

Can you start BIDS and then run SSIS project?