error on DTS scheduling

I am pretty new to SQL server. I have setup a DTS package that would
delete and then copy data from SQL server to DB2 on mainframe. I
installed the Host Intergration Server 2000 client to get OLEDB for
Db2. The DTS is working fine, when I run it myself from the server.
But when I schedule it it get the following error:
Executed as user: LOMBARD\sqlexec. DTSRun: Loading... DTSRun:
Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun
OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147217900 (80040E14)
Error string: Internal NetLib Error Error source: Microsoft
DB2 OLE DB Provider Help file: Help context: 0 Error
Detail Records: Error: -2147217900 (80040E14); Provider Error: 0
(0) Error string: Internal NetLib Error Error source:
Microsoft DB2 OLE DB Provider Help file: Help context: 0
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package
execution complete. Process Exit Code 1. The step failed.
I have been trying to solve this for the last couple of days, but not
getting anywhere...could somebody please help ?
Thanks
RogerThis is because (most probably) because when you schedule a package it runs
on the server so everything you need must be on the
scheduling server. You probably have the drivers installed on your workstat
ion which is why it works when you run it.
Have a look here
http://support.microsoft.com/?kbid=269074
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com
"sql rookie" <anytasks@.gmail.com> wrote in message news:1104952964.389735.87880@.z14g2000cwz.
googlegroups.com...
>I am pretty new to SQL server. I have setup a DTS package that would
> delete and then copy data from SQL server to DB2 on mainframe. I
> installed the Host Intergration Server 2000 client to get OLEDB for
> Db2. The DTS is working fine, when I run it myself from the server.
> But when I schedule it it get the following error:
> Executed as user: LOMBARD\sqlexec. DTSRun: Loading... DTSRun:
> Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun
> OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147217900 (80040E14)
> Error string: Internal NetLib Error Error source: Microsoft
> DB2 OLE DB Provider Help file: Help context: 0 Error
> Detail Records: Error: -2147217900 (80040E14); Provider Error: 0
> (0) Error string: Internal NetLib Error Error source:
> Microsoft DB2 OLE DB Provider Help file: Help context: 0
> DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package
> execution complete. Process Exit Code 1. The step failed.
>
> I have been trying to solve this for the last couple of days, but not
> getting anywhere...could somebody please help ?
> Thanks
> Roger
>|||You,
it sounds to me like a problem with users.
My aasumption is that you installed drivers for DB2 logged-in as
Administrator.
So everything is working when you run the DTS package as Administrator.
But when the package runs as LOMBARD\sqlexec it cannot find the drivers.
Maybe you can try and install the drivers also logged-in as sqlexec.
Danijel
"sql rookie" <anytasks@.gmail.com> wrote in message
news:1104955716.152873.292710@.z14g2000cwz.googlegroups.com...
> No , I executed the DTS on the server itself. I am using Terminal
> server to login to the server. I can execute the DTS via EM and also
> using DTSRUN on command line. But when I schedule it , it throws this
> error.
>|||No , I executed the DTS on the server itself. I am using Terminal
server to login to the server. I can execute the DTS via EM and also
using DTSRUN on command line. But when I schedule it , it throws this
error.|||There is a new developement on this:
I tried to change the sqlserver and agent service account to Local
systems and then the scheduling was working fine. I created a new
domain account , added it to the admin group to the server, made that
domain user the service account for sqlserver and agent. Gave sysadmin
privelege to the domain user. Now when I schedule it , I doesn't work.
I gives the same error
Am I doing something wrong ?
Please help