Re: DTS error -21472887 (80040E21)

From: BP Margolin (bpmargo@attglobal.net)
Date: 07/28/02 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Sat, 27 Jul 2002 21:35:27 -0400

Afkir,

Please do not post the same question independently to multiple newsgroups.

Please see my reply in .msde

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Afkir" <hafkir@hotmail.com> wrote in message
news:elGThUdNCHA.1964@tkmsftngp08...
> 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: MSDE and DTS packages
    ... I'm guessing you want to import dts packages into MSDE (if not my ... If you have a SQL Server then you can also use enterprise manager to simply ... > I have exported the dts package to a text file, but when I import it into ... I have looked in MSDN and found the dtswiz with command line switchs, ...
    (microsoft.public.sqlserver.msde)
  • RE: sql vs excel
    ... "Mike Epprecht (SQL MVP)" wrote: ... > You can create a DTS package in SQL server and then have MSDE run it. ...
    (microsoft.public.sqlserver.programming)
  • RE: sql vs excel
    ... You can create a DTS package in SQL server and then have MSDE run it. ... "Nikolami" wrote: ... > if I insert recordset into database, depends on datetime, other record will ...
    (microsoft.public.sqlserver.programming)
  • Re: Automating a job
    ... Create a dts package then right click and select schedule package ... > I have a new job and I would like to automate one mundane task I have to ... > Every day I run a query in query analyzer and if there are results I send ... I have a vb script which uses Windows ...
    (microsoft.public.sqlserver.programming)
  • MSDE and DTS packages
    ... I have developed my database on my SQL server and now have transfered it to MSDE with only one problem. ... I have exported the dts package to a text file, but when I import it into MSDE there is nothing there. ...
    (microsoft.public.sqlserver.msde)