June 7, 2004 at 9:18 am
I have a windows command file which 1)ftp's mainframe data into a text file, and 2)uses DTS to then insert this data into a SQL 2000 table. It works fine from the command prompt, or from Windows Explorer. However, when I have the job set up to run daily under Windows scheduler, it does not run the dtsrun command. According to both the scheduler and the dbadmin, the user name that scheduler is using is not authorized to access SQL. Any suggestions as to how I can get this to run successfully? Do I need to hard-code the user name and password into the dtsrun command line? Will this process work at all on a structured storage file, rather than embedded into the database? Any help would be greatly appreciated. The dtsrun command is in the format:
dtsrun /fall_ver2.1.dts /ncio contract monitoring package
June 7, 2004 at 12:26 pm
Task scheduler is like any other service it runs either under LocalSytem or a defined user. If you need a specific user rights on the SQL Server you need to set task schedualer to run under that user account instead (but keep in mind any rights that user has means that much task schedualer could be used to touch).
June 7, 2004 at 12:36 pm
Another thought would be to use SQL Server Agent to run the pacakge.
June 7, 2004 at 3:42 pm
Make sure the user name that creates the dts package has permissions to use sql agent as schedule job.
Also you can't use mapped drives in a schedule job.
Regards...
JFB
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply