"Andrew Robinson" <arx@miamidade.gov> wrote in message
news:dcbf7fe6.0406070642.a584d1a@posting.google.com...
> I have a Windows command file which ftp's data from the mainframe to a
> text file, then uses dts to insert the data into a SQL 2000 database.
> This procedure works without a hitch when I execute it from the
> command prompt, or from within Windows Explorer. My problem is, when I
> had this scheduled to run daily from the Windows scheduler, the
> command file runs, it does the ftp fine, but it will not execute the
> dtsrun command, which is in the format:
>
> dtsrun /fall_ver2.1.dts /ncio contract monitoring package
>
> According to both the dbadmin and the scheduler, this is due to the
> fact that the user name that scheduler is using does not have access
> to SQL. I really want to automate this process, rather than having to
> run it manually daily. Can anyone tell me what I need? Do I need to
> hard code an aythorized user name and password into the command file,
> which my supervisor doesn't really want me to do? Will this process
> work at all on a structured storage file, rather than a dts imbedded
> into the database? Any help would be greatly appreciated.