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