dbTalk Databases Forums  

Sendmail problem on DTS package scheduled with SQL Agent

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Sendmail problem on DTS package scheduled with SQL Agent in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Aaron Haley
 
Posts: n/a

Default Sendmail problem on DTS package scheduled with SQL Agent - 07-16-2003 , 04:42 PM






I know, I know. All of the MVPs are saying, no!! not this again. Go
read Q269074. I have, and everything else. I have jobs that were
working fine until last week. Now I get the dreaded and standard
error...
-------
Executed as user: TMANT\NTADMIN. DTSRun: Loading... Error:
-2147217900 (80040E14); Provider Error: 14262 (37B6) Error
string: The specified DTS Package ('Name = 'Daily Member Demographic
Updates'; ID.VersionID = {[not specified]}.{[not specified]}') does
not exist. Error source: Microsoft OLE DB Provider for SQL
Server Help file: Help context: 0. Process Exit Code 1.
The step failed.
-------

I have only one user involved, domain\ntadmin which is a domain admin
account. Ntadmin is the Agent startup and connection account and also
owns the DTS job, is the owner of the Agent job, and has access to the
mapi account. I can run the DTS package logged in as NTADMIN, but when
it runs automatically it errors out. It does not run whether I run the
Agent job by hand (logged into EM as SA or in WAM with the NTADMIN
account logged into the machine) or at it's scheduled time. I've
tested sendmail and it works as well as makes a valid mapi conenction.
Checked exchange and ntadmin has rights. I'm stumped?!!

Reply With Quote
  #2  
Old   
JFB
 
Posts: n/a

Default Re: Sendmail problem on DTS package scheduled with SQL Agent - 07-17-2003 , 03:22 PM






Hi Aaron,
Maybe this is you problem
http://msdn.microsoft.com/library/de...rovider_21.asp
JFB

"Aaron Haley" <aaron.haley (AT) texmed (DOT) org> wrote

Quote:
I know, I know. All of the MVPs are saying, no!! not this again. Go
read Q269074. I have, and everything else. I have jobs that were
working fine until last week. Now I get the dreaded and standard
error...
-------
Executed as user: TMANT\NTADMIN. DTSRun: Loading... Error:
-2147217900 (80040E14); Provider Error: 14262 (37B6) Error
string: The specified DTS Package ('Name = 'Daily Member Demographic
Updates'; ID.VersionID = {[not specified]}.{[not specified]}') does
not exist. Error source: Microsoft OLE DB Provider for SQL
Server Help file: Help context: 0. Process Exit Code 1.
The step failed.
-------

I have only one user involved, domain\ntadmin which is a domain admin
account. Ntadmin is the Agent startup and connection account and also
owns the DTS job, is the owner of the Agent job, and has access to the
mapi account. I can run the DTS package logged in as NTADMIN, but when
it runs automatically it errors out. It does not run whether I run the
Agent job by hand (logged into EM as SA or in WAM with the NTADMIN
account logged into the machine) or at it's scheduled time. I've
tested sendmail and it works as well as makes a valid mapi conenction.
Checked exchange and ntadmin has rights. I'm stumped?!!



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.