Unix Technical Forum

Permissions To Run DTS Package

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 ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 06:13 PM
Tom Loach
 
Posts: n/a
Default Permissions To Run DTS Package

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:58 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com