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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-20 : 08:32:02
|
| Rebecca writes "SQL Server 7.0 service pack 4.0I have DBO permissions to my database, but only user permissions to the server. I need to import data from an Excel spreadsheet into my database. When I do this, I get an error message stating that an "Error occurred during creation of a DTS package". This makes me think that I don't have the right premissions to the server itself. In order to get these permissions, I need to find out what permissions are needed. Any Ideas???" |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-06-24 : 10:52:43
|
| That all depends on where you're trying to save the DTS package to. For example, if you're trying to save the package to SQL Server, you will need permissions to the msdb database. There is info in BOL on each of the possible places to save a DTS package.Jeff BanschbachConsultant, MCDBA |
 |
|
|
|
|
|
SQL Permissions