Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SoleAris
Starting Member
3 Posts |
 Posted - 2012-05-04 : 14:01:33
|
| Hi everyone!I'm running into some problems when trying to import a single table from a software known as Add+On 7. This software basically holds all of our customer and item master records and in attempts to create a data pump from this ODBC to SQL Server 2008 I am getting some errors.Using the Import Wizard, I can connect to the ODBC fine, check the table that I wish to import, and see the fields, the data, etc in the preview pane. However, when actually running the import, I get an "unexpected unrecoverable error" at a few different points in the process. I've gotten it at the:1) "Validating" Step2) "Pre-Execute" Step3) "Execute" StepI'm wondering as to why I am getting these errors first of all as all of the data types seem to come across correctly. I am starting to think that it has something to do with permissions. The other individual that I am working with on this project is very particular (as he should be) with permission levels and it seems like this has given us some grief before now. Because I am not using an Admin account and am not given permission to some things, I feel like this could be the reason why I get warnings about "some changes may not be saved because you are not the owner of this table/object" among other things. Would simply using the Admin account to import this data (and ultimately create a data pump through a SSIS package) solve this issue I'm currently facing?Thanks for your help!!Sole |
|
|
|
|
|
Importing Table from an ODBC (Permissions Issue?)