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 |
|
william_lee78
Yak Posting Veteran
53 Posts |
 Posted - 2005-07-07 : 04:06:32
|
| Hi, Does anyone know what is the user account needed to run a schedule DTS Package, except SA? I'm currently using SA account, but this account is not appropriate for running the DTS package due to some security reasons. Can I create a new user to run the schedule DTS package? If yes, what are the right that I need to grant for the new user?Thank you in advance for the help.Regards,William |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-07-07 : 06:33:23
|
| you can set a user password for the dts, otherwise, check what are the required permissions for whatever is going on inside the package--------------------keeping it simple... |
 |
|
|
william_lee78
Yak Posting Veteran
53 Posts |
Posted - 2005-07-11 : 21:34:47
|
| Hi Jen, Thank you for your reply. Basically, my DTS package contains the following components:1. FileSystemObject2. ADOX.Catalog3. Run some SQL statement4. Transform Data TaskCan you guide me on what are the permissions needed in my case if I would like to create a new user instead of using SA to run my DTS package?Thank you.Regards,William |
|
|
|
|
|
|
Permission right for running DTS Package