DTS error -21472887 (80040E21)

From: Afkir (hafkir@hotmail.com)
Date: 07/28/02 

From: "Afkir" <hafkir@hotmail.com>
Date: Sat, 27 Jul 2002 21:22:08 -0700

Trying to run a DTS package from a stored procedure using xp_cmdshell but I
keep getting the
error string : error opening datafile: access is denied
 error source : Microsoft data transformation services flat file rowset
provider

Any idea, how to resolve that ??

xp_cmdshell 'dtsrun /Sserver_name /Uuser_nrame /Ppassword
/Npackage_name /Mpackage_password '

I logged on as : sa
when I run the same package manually through DTS, it runs.

Any suggestion ???

Relevant Pages

  • RE: Problem using GLobal Variables in DTS Package
    ... > I have created a DTS package, the data source is a stored procedure with an ... > The source connection for the transformation uses Microsoft OLE DB Provider ...
    (microsoft.public.sqlserver.dts)
  • Problem using GLobal Variables in DTS Package
    ... I use SQL 2K on a Win2K box ... I have created a DTS package, the data source is a stored procedure with an ...
    (microsoft.public.sqlserver.dts)
  • Re: Output Parameter To Global Variable (DTS)
    ... DECLARE @OutputTest1 int, @OutputTest2 int ... I am executing a stored procedure with 2 input> parameters and 2 output parameters. ... > The output params are causing me a headache. ... When I execute the DTS task, only the first output param from the> stored procedure is populated into the global variable in the DTS package. ...
    (microsoft.public.sqlserver.dts)
  • Re: Kick off job on-the-fly
    ... so write a stored procedure that calls the DTS, ... >> I have a scheduled job that executes a DTS package. ... we want the job (which executes a package) to be kicked off. ...
    (microsoft.public.vb.general.discussion)
  • Re: Error 1203
    ... I can't say it's reproducible, this stored procedure is one of several that run consecutively from a DTS package on a daily basis, the error happens on some days, and I can’t find a pattern yet. ... > As a workaround you could, probably, change your MAXDOP to 1 on the query or the server. ...
    (microsoft.public.sqlserver.programming)