Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Please help w/ DTS & ASP

3 views
Skip to first unread message

Basir

unread,
Jul 9, 2002, 2:37:40 PM7/9/02
to
Unable to run DTS from within ASP as explained in Q252987. Can someone help
please?

I get the following err # and err description:

-2147220499 No Steps have been defined for the transformation Package

Thanks in advance.

Basir


Allan Mitchell

unread,
Jul 9, 2002, 3:02:46 PM7/9/02
to
Forget ASP for a second

Can you run the package period ?

Sounds to me like maybe a data pump has been incorrectly defined (Not
defined). Go to the black lines between two connections and check in
there. Go through the tabs and DTS will shout when it falls over.


Allan


Allan Mitchell
www.SQLDTS.com


Basir

unread,
Jul 10, 2002, 9:10:05 AM7/10/02
to
Package runs properly directly from Enterprise Manager. However, in Query
Analyzer running

exec master..xp_cmdshell 'dtsrun /SServerName /Uuser /Ppassword
/NmyPackageName'

produces the following error:

(note that the input text file resides on the same workstation, with full
permissions given to Everyone.)

output


------------------------------------------------
----------------------------------------------------------------------------
-------------DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDataPumpTask_1
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147217887 (80040E21)
Error string: Error opening datafile: The device is not ready.
Error source: Microsoft Data Transformation Services Flat File Rowset
Provider
Help file: DTSFFile.hlp
Help context: 0
Error Detail Records:
Error: 21 (15); Provider Error: 21 (15)
Error string: Error opening datafile: The device is not ready.
Error source: Microsoft Data Transformation Services Flat File Rowset
Provider
Help file: DTSFFile.hlp
Help context: 0
DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
DTSRun: Package execution complete.
(21 row(s) affected)


"Allan Mitchell" <al...@no-spam-please.sqldts.com> wrote in message
news:3d2b32fb...@news.microsoft.com...

Allan Mitchell

unread,
Jul 10, 2002, 2:04:44 PM7/10/02
to
Looks

Looks to me like you cannot see the flat file.

Executing xp_cmdshell when a member of the sysadmin group on SQL
Server causes the query to run under the guise of the SQL Server
Service account , if not in the SYSADMIN group then it executes under
the proxy account


Are you a sysadmin ?
Who is your proxy ?
Who is your service account ?


Just because you've mapped a drive to a place doesn't mean anyone else
can see it/ Have permissions to it.

try using UNC for a start


Allan
www.SQLDTS.com


Allan Mitchell
www.SQLDTS.com


0 new messages