This is a discussion on Permissions To Run DTS Package within the SQL Server forums, part of the Microsoft SQL Server category; --> I have set up a DTS package to import a text file into a table. The DTS package is ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I have set up a DTS package to import a text file into a table. The DTS package is called from inside a VB program. Everything works fine as long as I as the sa run the package. Any other user who runs it will get an error message. The question I have is how do I gant permission to run the DTS package without having to make another user an sa? Thanks, Tom |