asked on

dts failed

expert,

I have one dts job failed, the error is:
Error: -2147217900 (80040E14); Provider Error: 2812 (AFC) Error string: Could not find stored procedure. I saw the store procedure is there.
what is the problem? Pl help!
Thank you,

Nathan Riley

Your not naming it correctly or your connection is to the wrong database

yrcdba7

ASKER

expert,

form dts job failed history it is:
Executed as user: domain\klEP. ...n OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSFTPTask_1 DTSRun OnFinish: DTSStep_DTSFTPTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart: DTSStep_DTSActiveScriptTask_3 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_3 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnError: DTSStep_DTSExecuteSQLTask_2, Error = -2147217900 (80040E14) Error string: Could not find stored procedure 'LL.SP_ABC_XSL'. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147217900 (80040E14); Provider Error: 2812 (AFC) Error string: Could not find stored procedure 'LL.SP_ABC_XSL'. Error source: Microsoft OLE DB Provider for SQL Server Help file: ... Process Exit Code 1. The step failed.

ASKER CERTIFIED SOLUTION

mohan_sekar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

yrcdba7

ASKER

Yes, LL is the owner

Nathan Riley

In your DTS package what database is your connection pointing to? What database is that SP in?

yrcdba7

ASKER

DTS package point to DB is pptt and sp is in the pptt db.