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.

Have you read this article?

http://support.microsoft.com/?kbid=269074

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Andrew Robinson" <arx (AT) miamidade (DOT) gov> wrote