>>>>>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?
>
>My current version of SQL Server is 2008 (not R2) and I am not sure right now which edition. I don't see any BI ability so would guess that is not installed either. Is it required to use import that can be saved?
Yes. To determine edition try
select SERVERPROPERTY('Edition')
If it's not broken, fix it until it is.
My Blog