DTS shedule error

Hey,
I have a DTS and I can execute him with no error.
This DTS is sheduled every day. But when the DTS is started up from the
shedule, he always fails.
He gives follwing error and I don't understand what is wrong.
Executed as user: OGEWS140\SYSTEM. DTSRun: Loading... DTSRun:
Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun
OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220421 (8004043B)
Error string: The task reported failure on execution. Error source:
Microsoft Data Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 1100 Error Detail Records: Error:
-2147220421 (8004043B); Provider Error: 0 (0) Error string: The task
reported failure on execution. Error source: Microsoft Data
Transformation Services (DTS) Package Help file: sqldts80.hlp Help
context: 1100 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun
OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_2 DTSRun: Package execution complete. Process
Exit Code 1. The step failed.
Tkx,
Jac
When you execute the package manually it is runs with your security
privileges. When you schedule it the user is OGEWS140\SYSTEM. I am guessing
that your system does not have privileges to do what you want.
"Jac" wrote:

> Hey,
> I have a DTS and I can execute him with no error.
> This DTS is sheduled every day. But when the DTS is started up from the
> shedule, he always fails.
> He gives follwing error and I don't understand what is wrong.
> Executed as user: OGEWS140\SYSTEM. DTSRun: Loading... DTSRun:
> Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun
> OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220421 (8004043B)
> Error string: The task reported failure on execution. Error source:
> Microsoft Data Transformation Services (DTS) Package Help file:
> sqldts80.hlp Help context: 1100 Error Detail Records: Error:
> -2147220421 (8004043B); Provider Error: 0 (0) Error string: The task
> reported failure on execution. Error source: Microsoft Data
> Transformation Services (DTS) Package Help file: sqldts80.hlp Help
> context: 1100 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun
> OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish:
> DTSStep_DTSExecuteSQLTask_2 DTSRun: Package execution complete. Process
> Exit Code 1. The step failed.
> Tkx,
> Jac
|||Hey,
I am not very well in security. So, how can I give the user OGEWS140\SYSTEM
all the security rights so he can execute a sheduled DTS
tkx,
Jac
"cathedr@.wa.state.gov" wrote:
[vbcol=seagreen]
> When you execute the package manually it is runs with your security
> privileges. When you schedule it the user is OGEWS140\SYSTEM. I am guessing
> that your system does not have privileges to do what you want.
> "Jac" wrote:
|||In Enterprise Manager, expand the server you are working on. Then expand the
Management Folder. Right-click the SQL Server Agent and choose Properties
from the pop-up menu. My guess is that you will find the Service startup
account set to System account. When you schedule a DTS package, the SQL
Server Agent is what starts the package. Since the Agent is starting the
package, that is the security context that the package runs in. If you need
the package to run in a different security context, you could specify that
the Agent use a different account. You could create a local account on the
server specifically for this purpose. If any of your jobs or packages will
need to perform administrator tasks, you should give the account appropriate
privileges on both the server and SQL server. The account will also need
privileges to any databases, procedures, etc. If your jobs or packages need
to communicate with other servers, you may need to use a domain account
rather than a local account. Another reason you may want to use a domain
account is in order to use SQL Mail. The startup account that I use for
Agent is a domain account that has an email account on Exchange.
Hope that helps...
Dan
"jac" wrote:
[vbcol=seagreen]
> Hey,
> I am not very well in security. So, how can I give the user OGEWS140\SYSTEM
> all the security rights so he can execute a sheduled DTS
> tkx,
> Jac
> "cathedr@.wa.state.gov" wrote:
|||Thanks a lot. That was a great help to me.
"cathedr@.wa.state.gov" wrote:
[vbcol=seagreen]
> In Enterprise Manager, expand the server you are working on. Then expand the
> Management Folder. Right-click the SQL Server Agent and choose Properties
> from the pop-up menu. My guess is that you will find the Service startup
> account set to System account. When you schedule a DTS package, the SQL
> Server Agent is what starts the package. Since the Agent is starting the
> package, that is the security context that the package runs in. If you need
> the package to run in a different security context, you could specify that
> the Agent use a different account. You could create a local account on the
> server specifically for this purpose. If any of your jobs or packages will
> need to perform administrator tasks, you should give the account appropriate
> privileges on both the server and SQL server. The account will also need
> privileges to any databases, procedures, etc. If your jobs or packages need
> to communicate with other servers, you may need to use a domain account
> rather than a local account. Another reason you may want to use a domain
> account is in order to use SQL Mail. The startup account that I use for
> Agent is a domain account that has an email account on Exchange.
> Hope that helps...
> Dan
> "jac" wrote:

DTS shedule error

Hey,
I have a DTS and I can execute him with no error.
This DTS is sheduled every day. But when the DTS is started up from the
shedule, he always fails.
He gives follwing error and I don't understand what is wrong.
Executed as user: OGEWS140\SYSTEM. DTSRun: Loading... DTSRun:
Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun
OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220421 (8004043B)
Error string: The task reported failure on execution. Error source:
Microsoft Data Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 1100 Error Detail Records: Error:
-2147220421 (8004043B); Provider Error: 0 (0) Error string: The task
reported failure on execution. Error source: Microsoft Data
Transformation Services (DTS) Package Help file: sqldts80.hlp Help
context: 1100 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun
OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_2 DTSRun: Package execution complete. Process
Exit Code 1. The step failed.
Tkx,
JacWhen you execute the package manually it is runs with your security
privileges. When you schedule it the user is OGEWS140\SYSTEM. I am guessing
that your system does not have privileges to do what you want.
"Jac" wrote:
> Hey,
> I have a DTS and I can execute him with no error.
> This DTS is sheduled every day. But when the DTS is started up from the
> shedule, he always fails.
> He gives follwing error and I don't understand what is wrong.
> Executed as user: OGEWS140\SYSTEM. DTSRun: Loading... DTSRun:
> Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun
> OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220421 (8004043B)
> Error string: The task reported failure on execution. Error source:
> Microsoft Data Transformation Services (DTS) Package Help file:
> sqldts80.hlp Help context: 1100 Error Detail Records: Error:
> -2147220421 (8004043B); Provider Error: 0 (0) Error string: The task
> reported failure on execution. Error source: Microsoft Data
> Transformation Services (DTS) Package Help file: sqldts80.hlp Help
> context: 1100 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun
> OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish:
> DTSStep_DTSExecuteSQLTask_2 DTSRun: Package execution complete. Process
> Exit Code 1. The step failed.
> Tkx,
> Jac|||Hey,
I am not very well in security. So, how can I give the user OGEWS140\SYSTEM
all the security rights so he can execute a sheduled DTS
tkx,
Jac
"cathedr@.wa.state.gov" wrote:
> When you execute the package manually it is runs with your security
> privileges. When you schedule it the user is OGEWS140\SYSTEM. I am guessing
> that your system does not have privileges to do what you want.
> "Jac" wrote:
> > Hey,
> >
> > I have a DTS and I can execute him with no error.
> > This DTS is sheduled every day. But when the DTS is started up from the
> > shedule, he always fails.
> > He gives follwing error and I don't understand what is wrong.
> >
> > Executed as user: OGEWS140\SYSTEM. DTSRun: Loading... DTSRun:
> > Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun
> > OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220421 (8004043B)
> > Error string: The task reported failure on execution. Error source:
> > Microsoft Data Transformation Services (DTS) Package Help file:
> > sqldts80.hlp Help context: 1100 Error Detail Records: Error:
> > -2147220421 (8004043B); Provider Error: 0 (0) Error string: The task
> > reported failure on execution. Error source: Microsoft Data
> > Transformation Services (DTS) Package Help file: sqldts80.hlp Help
> > context: 1100 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun
> > OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish:
> > DTSStep_DTSExecuteSQLTask_2 DTSRun: Package execution complete. Process
> > Exit Code 1. The step failed.
> >
> > Tkx,
> > Jac|||In Enterprise Manager, expand the server you are working on. Then expand the
Management Folder. Right-click the SQL Server Agent and choose Properties
from the pop-up menu. My guess is that you will find the Service startup
account set to System account. When you schedule a DTS package, the SQL
Server Agent is what starts the package. Since the Agent is starting the
package, that is the security context that the package runs in. If you need
the package to run in a different security context, you could specify that
the Agent use a different account. You could create a local account on the
server specifically for this purpose. If any of your jobs or packages will
need to perform administrator tasks, you should give the account appropriate
privileges on both the server and SQL server. The account will also need
privileges to any databases, procedures, etc. If your jobs or packages need
to communicate with other servers, you may need to use a domain account
rather than a local account. Another reason you may want to use a domain
account is in order to use SQL Mail. The startup account that I use for
Agent is a domain account that has an email account on Exchange.
Hope that helps...
Dan
"jac" wrote:
> Hey,
> I am not very well in security. So, how can I give the user OGEWS140\SYSTEM
> all the security rights so he can execute a sheduled DTS
> tkx,
> Jac
> "cathedr@.wa.state.gov" wrote:
> > When you execute the package manually it is runs with your security
> > privileges. When you schedule it the user is OGEWS140\SYSTEM. I am guessing
> > that your system does not have privileges to do what you want.
> >
> > "Jac" wrote:
> >
> > > Hey,
> > >
> > > I have a DTS and I can execute him with no error.
> > > This DTS is sheduled every day. But when the DTS is started up from the
> > > shedule, he always fails.
> > > He gives follwing error and I don't understand what is wrong.
> > >
> > > Executed as user: OGEWS140\SYSTEM. DTSRun: Loading... DTSRun:
> > > Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun
> > > OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220421 (8004043B)
> > > Error string: The task reported failure on execution. Error source:
> > > Microsoft Data Transformation Services (DTS) Package Help file:
> > > sqldts80.hlp Help context: 1100 Error Detail Records: Error:
> > > -2147220421 (8004043B); Provider Error: 0 (0) Error string: The task
> > > reported failure on execution. Error source: Microsoft Data
> > > Transformation Services (DTS) Package Help file: sqldts80.hlp Help
> > > context: 1100 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun
> > > OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish:
> > > DTSStep_DTSExecuteSQLTask_2 DTSRun: Package execution complete. Process
> > > Exit Code 1. The step failed.
> > >
> > > Tkx,
> > > Jac|||Thanks a lot. That was a great help to me.
"cathedr@.wa.state.gov" wrote:
> In Enterprise Manager, expand the server you are working on. Then expand the
> Management Folder. Right-click the SQL Server Agent and choose Properties
> from the pop-up menu. My guess is that you will find the Service startup
> account set to System account. When you schedule a DTS package, the SQL
> Server Agent is what starts the package. Since the Agent is starting the
> package, that is the security context that the package runs in. If you need
> the package to run in a different security context, you could specify that
> the Agent use a different account. You could create a local account on the
> server specifically for this purpose. If any of your jobs or packages will
> need to perform administrator tasks, you should give the account appropriate
> privileges on both the server and SQL server. The account will also need
> privileges to any databases, procedures, etc. If your jobs or packages need
> to communicate with other servers, you may need to use a domain account
> rather than a local account. Another reason you may want to use a domain
> account is in order to use SQL Mail. The startup account that I use for
> Agent is a domain account that has an email account on Exchange.
> Hope that helps...
> Dan
> "jac" wrote:
> > Hey,
> >
> > I am not very well in security. So, how can I give the user OGEWS140\SYSTEM
> > all the security rights so he can execute a sheduled DTS
> >
> > tkx,
> > Jac
> >
> > "cathedr@.wa.state.gov" wrote:
> >
> > > When you execute the package manually it is runs with your security
> > > privileges. When you schedule it the user is OGEWS140\SYSTEM. I am guessing
> > > that your system does not have privileges to do what you want.
> > >
> > > "Jac" wrote:
> > >
> > > > Hey,
> > > >
> > > > I have a DTS and I can execute him with no error.
> > > > This DTS is sheduled every day. But when the DTS is started up from the
> > > > shedule, he always fails.
> > > > He gives follwing error and I don't understand what is wrong.
> > > >
> > > > Executed as user: OGEWS140\SYSTEM. DTSRun: Loading... DTSRun:
> > > > Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun
> > > > OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220421 (8004043B)
> > > > Error string: The task reported failure on execution. Error source:
> > > > Microsoft Data Transformation Services (DTS) Package Help file:
> > > > sqldts80.hlp Help context: 1100 Error Detail Records: Error:
> > > > -2147220421 (8004043B); Provider Error: 0 (0) Error string: The task
> > > > reported failure on execution. Error source: Microsoft Data
> > > > Transformation Services (DTS) Package Help file: sqldts80.hlp Help
> > > > context: 1100 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun
> > > > OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish:
> > > > DTSStep_DTSExecuteSQLTask_2 DTSRun: Package execution complete. Process
> > > > Exit Code 1. The step failed.
> > > >
> > > > Tkx,
> > > > Jac

DTS shedule error

Hey,
I have a DTS and I can execute him with no error.
This DTS is sheduled every day. But when the DTS is started up from the
shedule, he always fails.
He gives follwing error and I don't understand what is wrong.
Executed as user: OGEWS140\SYSTEM. DTSRun: Loading... DTSRun:
Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun
OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220421 (8004043B)
Error string: The task reported failure on execution. Error source:
Microsoft Data Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 1100 Error Detail Records: Error:
-2147220421 (8004043B); Provider Error: 0 (0) Error string: The task
reported failure on execution. Error source: Microsoft Data
Transformation Services (DTS) Package Help file: sqldts80.hlp Hel
p
context: 1100 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun
OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_2 DTSRun: Package execution complete. Process
Exit Code 1. The step failed.
Tkx,
JacWhen you execute the package manually it is runs with your security
privileges. When you schedule it the user is OGEWS140\SYSTEM. I am guessin
g
that your system does not have privileges to do what you want.
"Jac" wrote:

> Hey,
> I have a DTS and I can execute him with no error.
> This DTS is sheduled every day. But when the DTS is started up from the
> shedule, he always fails.
> He gives follwing error and I don't understand what is wrong.
> Executed as user: OGEWS140\SYSTEM. DTSRun: Loading... DTSRun:
> Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun
> OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220421 (8004043B)
> Error string: The task reported failure on execution. Error source:
> Microsoft Data Transformation Services (DTS) Package Help file:
> sqldts80.hlp Help context: 1100 Error Detail Records: Erro
r:
> -2147220421 (8004043B); Provider Error: 0 (0) Error string: The tas
k
> reported failure on execution. Error source: Microsoft Data
> Transformation Services (DTS) Package Help file: sqldts80.hlp H
elp
> context: 1100 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSR
un
> OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish:
> DTSStep_DTSExecuteSQLTask_2 DTSRun: Package execution complete. Proces
s
> Exit Code 1. The step failed.
> Tkx,
> Jac|||Hey,
I am not very well in security. So, how can I give the user OGEWS140\SYSTEM
all the security rights so he can execute a sheduled DTS
tkx,
Jac
"cathedr@.wa.state.gov" wrote:
[vbcol=seagreen]
> When you execute the package manually it is runs with your security
> privileges. When you schedule it the user is OGEWS140\SYSTEM. I am guess
ing
> that your system does not have privileges to do what you want.
> "Jac" wrote:
>|||In Enterprise Manager, expand the server you are working on. Then expand th
e
Management Folder. Right-click the SQL Server Agent and choose Properties
from the pop-up menu. My guess is that you will find the Service startup
account set to System account. When you schedule a DTS package, the SQL
Server Agent is what starts the package. Since the Agent is starting the
package, that is the security context that the package runs in. If you need
the package to run in a different security context, you could specify that
the Agent use a different account. You could create a local account on the
server specifically for this purpose. If any of your jobs or packages will
need to perform administrator tasks, you should give the account appropriate
privileges on both the server and SQL server. The account will also need
privileges to any databases, procedures, etc. If your jobs or packages need
to communicate with other servers, you may need to use a domain account
rather than a local account. Another reason you may want to use a domain
account is in order to use SQL Mail. The startup account that I use for
Agent is a domain account that has an email account on Exchange.
Hope that helps...
Dan
"jac" wrote:
[vbcol=seagreen]
> Hey,
> I am not very well in security. So, how can I give the user OGEWS140\SYSTE
M
> all the security rights so he can execute a sheduled DTS
> tkx,
> Jac
> "cathedr@.wa.state.gov" wrote:
>|||Thanks a lot. That was a great help to me.
"cathedr@.wa.state.gov" wrote:
[vbcol=seagreen]
> In Enterprise Manager, expand the server you are working on. Then expand
the
> Management Folder. Right-click the SQL Server Agent and choose Properties
> from the pop-up menu. My guess is that you will find the Service startup
> account set to System account. When you schedule a DTS package, the SQL
> Server Agent is what starts the package. Since the Agent is starting the
> package, that is the security context that the package runs in. If you ne
ed
> the package to run in a different security context, you could specify that
> the Agent use a different account. You could create a local account on th
e
> server specifically for this purpose. If any of your jobs or packages wil
l
> need to perform administrator tasks, you should give the account appropria
te
> privileges on both the server and SQL server. The account will also need
> privileges to any databases, procedures, etc. If your jobs or packages ne
ed
> to communicate with other servers, you may need to use a domain account
> rather than a local account. Another reason you may want to use a domain
> account is in order to use SQL Mail. The startup account that I use for
> Agent is a domain account that has an email account on Exchange.
> Hope that helps...
> Dan
> "jac" wrote:
>sqlsql

DTS Scheduled Job

I am getting the following error whenever I execute
the job via sql server job agent. When I execute
the job package manually via dts the result is good.
Should I mount the physical drive to the main server?
Executed as user: card\sql. DTSRun: Loading... DTSRun:
Executing...
DTSRun OnStart: Copy Data from Results to S:\test.xls
Step DTSRun OnError: Copy Data from Results to
S:\test.xls Step,
Error = -2147467259 (80004005)
Error string: Error opening datafile: The system cannot
find the path specified.
Error source: Microsoft Data Transformation Services Flat
File Rowset Provider
Help file: DTSFFile.hlp Help context: 0
Error Detail Records: Error: 3 (3); Provider Error:
3 (3)
Error string: Error opening datafile: The system cannot
find the path specified.
Error source: Microsoft Data Transformation Services Flat
File Rowset Provider
Help file: DTSFFile.hlp Help context: 0
DTSRun OnFinish: Copy Data from Results to S:\test.xls
Step
DTSRun: Package execution complete. Process Exit Code
1.
The step failed.DTS is a client tool and thus when you run it from EM it's running
on your pc. If the server doesn't have an S drive then you'll get this
error. It's best to use UNC paths to avoid ambiguity. Also check out
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q269074
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"L Dominguez" <ldominguez@.cardionet.com> wrote in message
news:02af01c34730$9a2823b0$a601280a@.phx.gbl...
I am getting the following error whenever I execute
the job via sql server job agent. When I execute
the job package manually via dts the result is good.
Should I mount the physical drive to the main server?
Executed as user: card\sql. DTSRun: Loading... DTSRun:
Executing...
DTSRun OnStart: Copy Data from Results to S:\test.xls
Step DTSRun OnError: Copy Data from Results to
S:\test.xls Step,
Error = -2147467259 (80004005)
Error string: Error opening datafile: The system cannot
find the path specified.
Error source: Microsoft Data Transformation Services Flat
File Rowset Provider
Help file: DTSFFile.hlp Help context: 0
Error Detail Records: Error: 3 (3); Provider Error:
3 (3)
Error string: Error opening datafile: The system cannot
find the path specified.
Error source: Microsoft Data Transformation Services Flat
File Rowset Provider
Help file: DTSFFile.hlp Help context: 0
DTSRun OnFinish: Copy Data from Results to S:\test.xls
Step
DTSRun: Package execution complete. Process Exit Code
1.
The step failed.

DTS runs OK, but not scheduled job

Hi,
When I run DTS manually, it works fine. But when I run the scheduled job, it
failes.
The error said cannot find a file specified. It imports Excel file to
SQL2000 Server database. I set same domain user id for DTS creater and Agent
executer and job owner.
I read several articles same problem like this, but I haven't get solution...
Thank you,
Masako
Where is located the EXCEL File?
It should be located on server and not on the your workstation.
"Masako" <Masako@.discussions.microsoft.com> wrote in message
news:949CB8A5-FC52-4D2D-9208-F8FD750EE40C@.microsoft.com...
> Hi,
> When I run DTS manually, it works fine. But when I run the scheduled job,
it
> failes.
> The error said cannot find a file specified. It imports Excel file to
> SQL2000 Server database. I set same domain user id for DTS creater and
Agent
> executer and job owner.
> I read several articles same problem like this, but I haven't get
solution...
> --
> Thank you,
|||Hi Uri,
Does it have to? The Excel file is located on another server.
I had no problem like this job flow previous SQL Server. We used to Windows
NT server + SQL7, now new server is Windows2000 english version + SQL2000
Japanese version.
"Uri Dimant" wrote:

> Masako
> Where is located the EXCEL File?
> It should be located on server and not on the your workstation.
>
> "Masako" <Masako@.discussions.microsoft.com> wrote in message
> news:949CB8A5-FC52-4D2D-9208-F8FD750EE40C@.microsoft.com...
> it
> Agent
> solution...
>
>
|||Maskao
Make sure that SQL Server Agent is running under Domain Account not a Local
account.
"Masako" <Masako@.discussions.microsoft.com> wrote in message
news:CC48C0DC-A9F9-4E3A-8277-F6C55BF6C588@.microsoft.com...
> Hi Uri,
> Does it have to? The Excel file is located on another server.
> I had no problem like this job flow previous SQL Server. We used to
Windows[vbcol=seagreen]
> NT server + SQL7, now new server is Windows2000 english version + SQL2000
> Japanese version.
> "Uri Dimant" wrote:
job,[vbcol=seagreen]

DTS runs OK, but not scheduled job

Hi,
When I run DTS manually, it works fine. But when I run the scheduled job, it
failes.
The error said cannot find a file specified. It imports Excel file to
SQL2000 Server database. I set same domain user id for DTS creater and Agent
executer and job owner.
I read several articles same problem like this, but I haven't get solution..
.
Thank you,Masako
Where is located the EXCEL File?
It should be located on server and not on the your workstation.
"Masako" <Masako@.discussions.microsoft.com> wrote in message
news:949CB8A5-FC52-4D2D-9208-F8FD750EE40C@.microsoft.com...
> Hi,
> When I run DTS manually, it works fine. But when I run the scheduled job,
it
> failes.
> The error said cannot find a file specified. It imports Excel file to
> SQL2000 Server database. I set same domain user id for DTS creater and
Agent
> executer and job owner.
> I read several articles same problem like this, but I haven't get
solution...
> --
> Thank you,|||Hi Uri,
Does it have to? The Excel file is located on another server.
I had no problem like this job flow previous SQL Server. We used to Windows
NT server + SQL7, now new server is Windows2000 english version + SQL2000
Japanese version.
"Uri Dimant" wrote:

> Masako
> Where is located the EXCEL File?
> It should be located on server and not on the your workstation.
>
> "Masako" <Masako@.discussions.microsoft.com> wrote in message
> news:949CB8A5-FC52-4D2D-9208-F8FD750EE40C@.microsoft.com...
> it
> Agent
> solution...
>
>|||Maskao
Make sure that SQL Server Agent is running under Domain Account not a Local
account.
"Masako" <Masako@.discussions.microsoft.com> wrote in message
news:CC48C0DC-A9F9-4E3A-8277-F6C55BF6C588@.microsoft.com...
> Hi Uri,
> Does it have to? The Excel file is located on another server.
> I had no problem like this job flow previous SQL Server. We used to
Windows[vbcol=seagreen]
> NT server + SQL7, now new server is Windows2000 english version + SQL2000
> Japanese version.
> "Uri Dimant" wrote:
>
job,[vbcol=seagreen]

DTS runs OK, but not scheduled job

Hi,
When I run DTS manually, it works fine. But when I run the scheduled job, it
failes.
The error said cannot find a file specified. It imports Excel file to
SQL2000 Server database. I set same domain user id for DTS creater and Agent
executer and job owner.
I read several articles same problem like this, but I haven't get solution...
--
Thank you,Masako
Where is located the EXCEL File?
It should be located on server and not on the your workstation.
"Masako" <Masako@.discussions.microsoft.com> wrote in message
news:949CB8A5-FC52-4D2D-9208-F8FD750EE40C@.microsoft.com...
> Hi,
> When I run DTS manually, it works fine. But when I run the scheduled job,
it
> failes.
> The error said cannot find a file specified. It imports Excel file to
> SQL2000 Server database. I set same domain user id for DTS creater and
Agent
> executer and job owner.
> I read several articles same problem like this, but I haven't get
solution...
> --
> Thank you,|||Hi Uri,
Does it have to? The Excel file is located on another server.
I had no problem like this job flow previous SQL Server. We used to Windows
NT server + SQL7, now new server is Windows2000 english version + SQL2000
Japanese version.
"Uri Dimant" wrote:
> Masako
> Where is located the EXCEL File?
> It should be located on server and not on the your workstation.
>
> "Masako" <Masako@.discussions.microsoft.com> wrote in message
> news:949CB8A5-FC52-4D2D-9208-F8FD750EE40C@.microsoft.com...
> > Hi,
> >
> > When I run DTS manually, it works fine. But when I run the scheduled job,
> it
> > failes.
> > The error said cannot find a file specified. It imports Excel file to
> > SQL2000 Server database. I set same domain user id for DTS creater and
> Agent
> > executer and job owner.
> >
> > I read several articles same problem like this, but I haven't get
> solution...
> >
> > --
> > Thank you,
>
>|||Maskao
Make sure that SQL Server Agent is running under Domain Account not a Local
account.
"Masako" <Masako@.discussions.microsoft.com> wrote in message
news:CC48C0DC-A9F9-4E3A-8277-F6C55BF6C588@.microsoft.com...
> Hi Uri,
> Does it have to? The Excel file is located on another server.
> I had no problem like this job flow previous SQL Server. We used to
Windows
> NT server + SQL7, now new server is Windows2000 english version + SQL2000
> Japanese version.
> "Uri Dimant" wrote:
> > Masako
> > Where is located the EXCEL File?
> > It should be located on server and not on the your workstation.
> >
> >
> > "Masako" <Masako@.discussions.microsoft.com> wrote in message
> > news:949CB8A5-FC52-4D2D-9208-F8FD750EE40C@.microsoft.com...
> > > Hi,
> > >
> > > When I run DTS manually, it works fine. But when I run the scheduled
job,
> > it
> > > failes.
> > > The error said cannot find a file specified. It imports Excel file to
> > > SQL2000 Server database. I set same domain user id for DTS creater and
> > Agent
> > > executer and job owner.
> > >
> > > I read several articles same problem like this, but I haven't get
> > solution...
> > >
> > > --
> > > Thank you,
> >
> >
> >

DTS problem

Hi,
I am trying to export data into EXCEL sheet using DTS, It is working fine
for single user, however it fails with error messages when tried by multiple
users at the same time...So is it limitation of DTS as it does not run
simultaneously ?Is the destination Excel Workbook the same for all users?
If it is, then that's why the DTS package fails. If that's not the case,
please post the actual error message.
ML|||Hi ML,
It is the same excel but user can change the path and each one is exporting
it in different folders, so I feel it should not be the case.
Errors is shown like :
"Microsoft Database Engine canot open the file ", It is already opened
exculisevely by another user, or you need permission to view data.
Is this because every user is using single user(user name + pwd, is provided
thru config file), with special permission, to fetch data from different
tables.
Thanks
"ML" wrote:

> Is the destination Excel Workbook the same for all users?
> If it is, then that's why the DTS package fails. If that's not the case,
> please post the actual error message.
>
> ML|||Judging by the error message all users are trying to access the same Excel
file.
You say they have the option of changing the output path - at what point in
time are they allowed to change it? Before or after executing the DTS packag
e?
ML|||It is through input box, which is displayed through VB script and that is th
e
part of DTS package. So It happens during the execution of DTS package.
"ML" wrote:

> Judging by the error message all users are trying to access the same Excel
> file.
> You say they have the option of changing the output path - at what point i
n
> time are they allowed to change it? Before or after executing the DTS pack
age?
>
> ML|||If the error occurs before this VB script is executed, then the connection t
o
the Excel file is made before the user selects the output file - which means
the connection is made to the same file for each user.
However, if the error occurs after the user has selected a different output
file, then it seems that the connection is not made to the file the user
selected.
Maybe you could create a new file for each user at the beginning of the
package, and establish a connection dynamically:
1) open a new file using VBS;
2) name the file by embedding the user's name and a timestamp (e.g.
"Output_John_200510301255.xls");
3) passing the filename as a global variable to the data connection.
ML

DTS Problem

I'm getting the error message
Server.CreateObject Failed
when running a dts package. Been searching around, it recommended
re-registering the 5 dts*.dll files on the system.
All but one re-registered without a problem, however, the dtswiz.dll file
didn't - I got this error message
"dtswiz.dll was loaded, but the DllRegisterServer entry point was not found.
This file can not be registered."
Thanks for any help.Try removing it from your server, running a reg clean then
putting it back on and registering it.
Peter
"A man is never more truthful than when he acknowledges
himself a liar."
Mark Twain
>--Original Message--
>I'm getting the error message
>Server.CreateObject Failed
>when running a dts package. Been searching around, it
recommended
>re-registering the 5 dts*.dll files on the system.
>All but one re-registered without a problem, however, the
dtswiz.dll file
>didn't - I got this error message
>"dtswiz.dll was loaded, but the DllRegisterServer entry
point was not found.
>This file can not be registered."
>
>Thanks for any help.
>
>
>.
>|||Thanks for getting back to me peter
Been looking for info on running a registry clean - any advice?
Rich
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:0baf01c49ff0$10833c20$a601280a@.phx.gbl...
> Try removing it from your server, running a reg clean then
> putting it back on and registering it.
> Peter
> "A man is never more truthful than when he acknowledges
> himself a liar."
> Mark Twain
>
>>--Original Message--
>>I'm getting the error message
>>Server.CreateObject Failed
>>when running a dts package. Been searching around, it
> recommended
>>re-registering the 5 dts*.dll files on the system.
>>All but one re-registered without a problem, however, the
> dtswiz.dll file
>>didn't - I got this error message
>>"dtswiz.dll was loaded, but the DllRegisterServer entry
> point was not found.
>>This file can not be registered."
>>
>>Thanks for any help.
>>
>>
>>.

dts prob

Whenever i right click on an open dts and
choose "disconnect edit" i get this error:
Error Souce: Microsoft OLE DB Service Components
Error Description: Class not registered
Class not registered
Can anyone tell me why? How to i fix this'
Thanxs> Whenever i right click on an open dts and
> choose "disconnect edit" i get this error:
> Error Souce: Microsoft OLE DB Service Components
> Error Description: Class not registered
> Class not registered
> Can anyone tell me why? How to i fix this'
> Thanxs
--
Reinstall MDAC and see how that goes. If that fails, get a regmon and
filemon capture to determine what dll is missing/unregistered.
Hope this helps,
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.sqlsql

DTS Pkg Job error

I recently installed a new SQL Server and am having problems scheduling my DTS packages. They will work fine if I manually execute them, but none of them will fire from a job.

Regardless of the DTS package scheduled it fails with the following error:

Executed as user: STANDREWS\SYSTEM. The process could not be created for step 1
 of job 0x8D49E4684F14CB49BFC9223F4E47FC16 (reason: The system cannot find the file
specified). The step failed.

I have tried all kinds of stuff to no avail.What does step 1 look like? Did you try specifying the entire path for dtsrun.exe?

Terri|||when they fire from a job, they are firing under the security context of the account that the SQL Agent uses.

Therefore i would conclude that your account has access to something that the SQL Agent account does not.

you could set the SQL Agent to use a specific machine account...|||Yeah, created the job in various fashions, by name, by GUID, etc, etc. I am not certain of the absolute file path though, where is that found?

I will also check the SQL Agent security.|||The absolute file path is the physical path to dtsrun.exe on the SQL Server. On my local SQL Server, e.g., it can be found here: C:\Program Files\Microsoft SQL Server\80\Tools\Binn\dtsrun.exe

I am bringing this up because I have come across this problem in the past.KB 322746 - PRB: Data Transformation Services Jobs May Fail Because the Path for Dtsrun.exe Cannot Be Found addresses this.

Terrisqlsql

DTS Packages Unspecified Error

WE have dts packages created with ftp component in Sql 2000 dts designer. At the same time client where we are developing the package has sql 2005 components. When we move this package to sql 2000 production server - we can execute nor we can open the package it will give unspecified error.

if we recreate the package on client which does not have sql 2005 component than only it works. So for any mistake the packge once opened in sql 2000 designer also with client having sql 2005 components it does not work. Only criteria this error happens when you have ftp component used in dts package.

Did anyone has seen this problem ? Any fixes or patches available to be applied ?

Thanks for the help.

Manoj

Hi

Microsoft already know this problem but dont release the hotfix, you need to contact them.

http://support.microsoft.com/kb/890841

I have the same problem and to fixe it, I recovered an old version of DTS through the server and made the modifications.

If you found a better way please contact me.

Thanks

|||

Thanks

Looks like this hotfix should resolve the issue, I will touchbase with microsoft and will try to install the hotfix.

Let you know.

Manoj

|||

I tried after applying the hotfix - it did not work.

Manoj

|||I'm having the same problem. Did you every get this fixed?|||DTS is provided for the backward compatibility in SQL 2005, you might need to rewrite the same in SSIS to provide the functionality.sqlsql

DTS Packages Unspecified Error

WE have dts packages created with ftp component in Sql 2000 dts designer. At the same time client where we are developing the package has sql 2005 components. When we move this package to sql 2000 production server - we can execute nor we can open the package it will give unspecified error.

if we recreate the package on client which does not have sql 2005 component than only it works. So for any mistake the packge once opened in sql 2000 designer also with client having sql 2005 components it does not work. Only criteria this error happens when you have ftp component used in dts package.

Did anyone has seen this problem ? Any fixes or patches available to be applied ?

Thanks for the help.

Manoj

Hi

Microsoft already know this problem but dont release the hotfix, you need to contact them.

http://support.microsoft.com/kb/890841

I have the same problem and to fixe it, I recovered an old version of DTS through the server and made the modifications.

If you found a better way please contact me.

Thanks

|||

Thanks

Looks like this hotfix should resolve the issue, I will touchbase with microsoft and will try to install the hotfix.

Let you know.

Manoj

|||

I tried after applying the hotfix - it did not work.

Manoj

|||I'm having the same problem. Did you every get this fixed?|||DTS is provided for the backward compatibility in SQL 2005, you might need to rewrite the same in SSIS to provide the functionality.

DTS Packages Unspecified Error

WE have dts packages created with ftp component in Sql 2000 dts designer. At the same time client where we are developing the package has sql 2005 components. When we move this package to sql 2000 production server - we can execute nor we can open the package it will give unspecified error.

if we recreate the package on client which does not have sql 2005 component than only it works. So for any mistake the packge once opened in sql 2000 designer also with client having sql 2005 components it does not work. Only criteria this error happens when you have ftp component used in dts package.

Did anyone has seen this problem ? Any fixes or patches available to be applied ?

Thanks for the help.

Manoj

Hi

Microsoft already know this problem but dont release the hotfix, you need to contact them.

http://support.microsoft.com/kb/890841

I have the same problem and to fixe it, I recovered an old version of DTS through the server and made the modifications.

If you found a better way please contact me.

Thanks

|||

Thanks

Looks like this hotfix should resolve the issue, I will touchbase with microsoft and will try to install the hotfix.

Let you know.

Manoj

|||

I tried after applying the hotfix - it did not work.

Manoj

|||I'm having the same problem. Did you every get this fixed?|||DTS is provided for the backward compatibility in SQL 2005, you might need to rewrite the same in SSIS to provide the functionality.

DTS Packages are not working as job

Hello,

I scheduled a dts package and it created automatically a job but the job fails with following error :
(reason: The system cannot find the file specified).

dts package is connecting the databases which exist on the server and I created this dts package on the same server as user sa.

I don't use a file as a data source or for something else in the package.

Server is SQL 2000 with SP3 and operating system is win2k.

I hope there is someone who has an idea...

elifElif:

What EXACTLY is you package doing? In other words, are you using ActiveX + VBS to create and Run the job?

RobbieD|||My package is copying a database into another one and changing some characters in some fields. I added a vb code to transformations screen for this.
The package works fine when executed. Problem is scheduling. I want to execute it at night because the people are working one of the databases which dts uses.

If I can not schedule this I have to schedule my own night or weekend. This is ridiculous.|||...SO you have already right-clicked the package in Enterprise Manager, selected Schedule Package - but that doesn't work, right?|||Originally posted by robbied111
...SO you have already right-clicked the package in Enterprise Manager, selected Schedule Package - but that doesn't work, right?

It worked and created the job. The problem is the "job". That does not work.|||I recall our DBA having the same issue:

I believe that the job may need to be scheduled directly on the server with the logged in user having admin priviledges on the server. It had less to do with SQL Server but was an effect of Windows 2000.

I may be offbase but that is what he found.

Originally posted by eguven
It worked and created the job. The problem is the "job". That does not work.|||The weather was stormy on friday, so we did not work.
Thanks for responses.
I'm working directly on the server and I'm user 'sa'.
I also prepared and scheduled the dts package on the server.
And this job does not work.
I have read something on the msdn related the user priviliges problem with this issue. That's why I did everything on the server as they said.
There is something else in my problem. I don't really understand.|||Dear friends,

I solved by myself this crazy problem. I wanted to share solution with you. When I scheduled the dts package, a job was created automatically. But it uses DTSRUN utility to run the package. This utility can only be run in the "c:\Program Files\Microsoft SQL Server\80\Tools\Binn " directory. I don't know why... But there is no path information in the job definition. That's why I recevied "File not found" message. I added this path to job and it worked. No need to be smart when working with a microft. We must just think simple.

bye

elif|||You might have removed it from the path variable while making some config settings ... otherwise it is automatically added when you install sql server .. You can view and set the path variables in System properties .. Advanced Tab ... Environment Variables ... No need to blame MS for your own fault. :)

DTS Package troubles

This summary is not available. Please click here to view the post.

DTS Package Timeout Error

I have two simple dts pacakges , DTS_Main and DTS_Sub.
DTS_Sub being called from DTS_Main.
When DTS_Main calls DTS_Sub getting the following timeout error while
calling the package not while executing.
Is there any settings I can set to increase the time out setting when
calling sub package.Both dts packages
exists in Same SQL server (SQL 2000 SP4 + Windows 2003), the server is 8
processor with 12 GB Ram.
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: Timeout expired Error source: Microsoft OLE DB Provider
for SQL Server
Help file:
Help context: 0.
Process Exit Code 1. The step failed.
Please advise.
Hello DK,
The error message seems to be more to do with connecting to your SQL
Server. First off are all the DTS packages on the same server?
If all DTS packages are on the same server try the following:
I would try and run the sub package independently of the main package.
Also I would test all the database connections in the DTS package.
Hope this helps,
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com/
|||Ran the main and sub packages individually they ran fine.
Both the packages are in the same server.I have tested all the connections
inside the packages.
I have changed the connection timeout for all connections to 600000
My question is while main package opening the sub package it's taking more
time, where I can change this
time out setting for opening dts packages..
<Myles.Matheson@.gmail.com> wrote in message
news:1130131342.421163.88560@.g49g2000cwa.googlegro ups.com...
> Hello DK,
> The error message seems to be more to do with connecting to your SQL
> Server. First off are all the DTS packages on the same server?
> If all DTS packages are on the same server try the following:
> I would try and run the sub package independently of the main package.
> Also I would test all the database connections in the DTS package.
> Hope this helps,
> Myles Matheson
> Data Warehouse Architect
> http://bi-on-sql-server.blogspot.com/
>
|||Hello DK,
This could be a permissions problem. Did you manually run the sub
package or scheduled it?
If you manually ran the package your user context would have been used.
This may include all the aliases for databases connections. The timeout
error could have been trying to connect on a different port requiring
an alias.
Are you using server aliases for you db connections?
Try scheduling the sub package on its own to see if you get the same
error. Or logon under the SQL agent account and the sub package.
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com/
|||> Ran the main and sub packages individually they ran fine.
If the main package ran fine, does that mean it runs OK from the
designer, but not as a scheduled job? If this is the case the issue is
probably that the account that SQL Agent is running under does not have
permission to run the packages.
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell
|||Since the DTS packages are on the same server why not create a job and have
the pacakges executed as separate steps?
Thomas
"Myles.Matheson@.gmail.com" wrote:

> Hello DK,
> The error message seems to be more to do with connecting to your SQL
> Server. First off are all the DTS packages on the same server?
> If all DTS packages are on the same server try the following:
> I would try and run the sub package independently of the main package.
> Also I would test all the database connections in the DTS package.
> Hope this helps,
> Myles Matheson
> Data Warehouse Architect
> http://bi-on-sql-server.blogspot.com/
>
|||i have many dts packages, so i want to include them in one package with
different conditions.
"Thomas" <Thomas@.discussions.microsoft.com> wrote in message
news:56580403-46BA-43BD-A334-8C96CF887B7F@.microsoft.com...
> Since the DTS packages are on the same server why not create a job and
have[vbcol=seagreen]
> the pacakges executed as separate steps?
> --
> Thomas
>
> "Myles.Matheson@.gmail.com" wrote:
sqlsql

DTS Package Timeout Error

I have two simple dts pacakges , DTS_Main and DTS_Sub.
DTS_Sub being called from DTS_Main.
When DTS_Main calls DTS_Sub getting the following timeout error while
calling the package not while executing.
Is there any settings I can set to increase the time out setting when
calling sub package.Both dts packages
exists in Same SQL server (SQL 2000 SP4 + Windows 2003), the server is 8
processor with 12 GB Ram.
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: Timeout expired Error source: Microsoft OLE DB Provider
for SQL Server
Help file:
Help context: 0.
Process Exit Code 1. The step failed.
Please advise.Hello DK,
The error message seems to be more to do with connecting to your SQL
Server. First off are all the DTS packages on the same server?
If all DTS packages are on the same server try the following:
I would try and run the sub package independently of the main package.
Also I would test all the database connections in the DTS package.
Hope this helps,
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com/|||Ran the main and sub packages individually they ran fine.
Both the packages are in the same server.I have tested all the connections
inside the packages.
I have changed the connection timeout for all connections to 600000
My question is while main package opening the sub package it's taking more
time, where I can change this
time out setting for opening dts packages..
<Myles.Matheson@.gmail.com> wrote in message
news:1130131342.421163.88560@.g49g2000cwa.googlegroups.com...
> Hello DK,
> The error message seems to be more to do with connecting to your SQL
> Server. First off are all the DTS packages on the same server?
> If all DTS packages are on the same server try the following:
> I would try and run the sub package independently of the main package.
> Also I would test all the database connections in the DTS package.
> Hope this helps,
> Myles Matheson
> Data Warehouse Architect
> http://bi-on-sql-server.blogspot.com/
>|||Hello DK,
This could be a permissions problem. Did you manually run the sub
package or scheduled it?
If you manually ran the package your user context would have been used.
This may include all the aliases for databases connections. The timeout
error could have been trying to connect on a different port requiring
an alias.
Are you using server aliases for you db connections?
Try scheduling the sub package on its own to see if you get the same
error. Or logon under the SQL agent account and the sub package.
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com/|||> Ran the main and sub packages individually they ran fine.
If the main package ran fine, does that mean it runs OK from the
designer, but not as a scheduled job? If this is the case the issue is
probably that the account that SQL Agent is running under does not have
permission to run the packages.
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell|||Since the DTS packages are on the same server why not create a job and have
the pacakges executed as separate steps?
--
Thomas
"Myles.Matheson@.gmail.com" wrote:

> Hello DK,
> The error message seems to be more to do with connecting to your SQL
> Server. First off are all the DTS packages on the same server?
> If all DTS packages are on the same server try the following:
> I would try and run the sub package independently of the main package.
> Also I would test all the database connections in the DTS package.
> Hope this helps,
> Myles Matheson
> Data Warehouse Architect
> http://bi-on-sql-server.blogspot.com/
>|||i have many dts packages, so i want to include them in one package with
different conditions.
"Thomas" <Thomas@.discussions.microsoft.com> wrote in message
news:56580403-46BA-43BD-A334-8C96CF887B7F@.microsoft.com...
> Since the DTS packages are on the same server why not create a job and
have[vbcol=seagreen]
> the pacakges executed as separate steps?
> --
> Thomas
>
> "Myles.Matheson@.gmail.com" wrote:
>

DTS Package Timeout error

I have two simple dts pacakges , DTS_Main and DTS_Sub.
DTS_Sub being called from DTS_Main.
When DTS_Main calls DTS_Sub getting the following timeout error while
calling the package not while executing.
Is there any settings I can set to increase the time out setting when
calling sub package.Both dts packages
exists in Same SQL server (SQL 2000 SP4 + Windows 2003), the server is 8
processor with 12 GB Ram.
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: Timeout expired Error source: Microsoft OLE DB Provider
for SQL Server
Help file:
Help context: 0.
Process Exit Code 1. The step failed.
Please advise.Hi
I have never seen this and don't know where you can set the timeout you may
want to post to microsoft.public.sqlserver.dts.
You don't say which version of SQL Server you are using, what version of
MDAC is installed and if the sub-package is a file or not.
Does the package work if run manually?
Does SQL profiler show anything?
John
"DKRReddy" wrote:

> I have two simple dts pacakges , DTS_Main and DTS_Sub.
> DTS_Sub being called from DTS_Main.
> When DTS_Main calls DTS_Sub getting the following timeout error while
> calling the package not while executing.
> Is there any settings I can set to increase the time out setting when
> calling sub package.Both dts packages
> exists in Same SQL server (SQL 2000 SP4 + Windows 2003), the server is 8
> processor with 12 GB Ram.
> Error: -2147467259 (80004005); Provider Error: 0 (0)
> Error string: Timeout expired Error source: Microsoft OLE DB Provid
er
> for SQL Server
> Help file:
> Help context: 0.
> Process Exit Code 1. The step failed.
>
> Please advise.
>
>

DTS Package Timeout error

I have two simple dts pacakges , DTS_Main and DTS_Sub.
DTS_Sub being called from DTS_Main.
When DTS_Main calls DTS_Sub getting the following timeout error while
calling the package not while executing.
Is there any settings I can set to increase the time out setting when
calling sub package.Both dts packages
exists in Same SQL server (SQL 2000 SP4 + Windows 2003), the server is 8
processor with 12 GB Ram.
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: Timeout expired Error source: Microsoft OLE DB Provider
for SQL Server
Help file:
Help context: 0.
Process Exit Code 1. The step failed.
Please advise.
Hi
I have never seen this and don't know where you can set the timeout you may
want to post to microsoft.public.sqlserver.dts.
You don't say which version of SQL Server you are using, what version of
MDAC is installed and if the sub-package is a file or not.
Does the package work if run manually?
Does SQL profiler show anything?
John
"DKRReddy" wrote:

> I have two simple dts pacakges , DTS_Main and DTS_Sub.
> DTS_Sub being called from DTS_Main.
> When DTS_Main calls DTS_Sub getting the following timeout error while
> calling the package not while executing.
> Is there any settings I can set to increase the time out setting when
> calling sub package.Both dts packages
> exists in Same SQL server (SQL 2000 SP4 + Windows 2003), the server is 8
> processor with 12 GB Ram.
> Error: -2147467259 (80004005); Provider Error: 0 (0)
> Error string: Timeout expired Error source: Microsoft OLE DB Provider
> for SQL Server
> Help file:
> Help context: 0.
> Process Exit Code 1. The step failed.
>
> Please advise.
>
>