I am just starting to learn DTS.
If I set up in a DTS package a series of 5 independant processes, each of
which Deletes rows out of it's respective table and then loads their
respective flat file into those tables.... Will all of these run
concurrently? I have them all tied to the same connection object, but that
should not prevent them from running concurrently...wil it?Jim,
Yes it will. if they use the same connection, it will prevent them from
running concurrently.
You can notice it in DTS Designer, when moving huge amount of data between
source and target using the same connection. The transformation steps
(datapumps) will run in sequence no matter if they were setup to run
concurrently.
AMB
"Jim Heavey" wrote:
> I am just starting to learn DTS.
> If I set up in a DTS package a series of 5 independant processes, each of
> which Deletes rows out of it's respective table and then loads their
> respective flat file into those tables.... Will all of these run
> concurrently? I have them all tied to the same connection object, but that
> should not prevent them from running concurrently...wil it?
>|||http://www.codeproject.com/useritems/DTS__VBNET_.asp
Thursday, March 29, 2012
DTS Simple Question
I am just starting to learn DTS.
If I set up in a DTS package a series of 5 independant processes, each of
which Deletes rows out of it's respective table and then loads their
respective flat file into those tables.... Will all of these run
concurrently? I have them all tied to the same connection object, but that
should not prevent them from running concurrently...wil it?
Jim,
Yes it will. if they use the same connection, it will prevent them from
running concurrently.
You can notice it in DTS Designer, when moving huge amount of data between
source and target using the same connection. The transformation steps
(datapumps) will run in sequence no matter if they were setup to run
concurrently.
AMB
"Jim Heavey" wrote:
> I am just starting to learn DTS.
> If I set up in a DTS package a series of 5 independant processes, each of
> which Deletes rows out of it's respective table and then loads their
> respective flat file into those tables.... Will all of these run
> concurrently? I have them all tied to the same connection object, but that
> should not prevent them from running concurrently...wil it?
>
If I set up in a DTS package a series of 5 independant processes, each of
which Deletes rows out of it's respective table and then loads their
respective flat file into those tables.... Will all of these run
concurrently? I have them all tied to the same connection object, but that
should not prevent them from running concurrently...wil it?
Jim,
Yes it will. if they use the same connection, it will prevent them from
running concurrently.
You can notice it in DTS Designer, when moving huge amount of data between
source and target using the same connection. The transformation steps
(datapumps) will run in sequence no matter if they were setup to run
concurrently.
AMB
"Jim Heavey" wrote:
> I am just starting to learn DTS.
> If I set up in a DTS package a series of 5 independant processes, each of
> which Deletes rows out of it's respective table and then loads their
> respective flat file into those tables.... Will all of these run
> concurrently? I have them all tied to the same connection object, but that
> should not prevent them from running concurrently...wil it?
>
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:
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
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
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 services
HI to all,
well I am facing a very critical problem, Let me explain the situattion first.
We are managing two applications , One is using Microsoft Sql Server (Desktop application )and the other one is using the MYsql(Web application ).
Both applications are for the same business, having exactly the same database. Now we have to keep two different Data servers as we don't want to Re-code.
Is there any way that our both servers are sychonised. I mean Can we have a solution that the Copy of the data entered in the Mysql can be tranferred to the SQLserver and vice versa.
I guess the SQL server DTS (data transforming services) can help but i am not sure will it be possible.
THx and regards.In Books Online, you should look at Synchronization. That said, I am not sure how (or if) two way synchronization is possible with heterogenous databases (db's from 2 different vendors).
DTS Server
Hi,
Can someone tell me how to start DTS Server in SQL 2005 beta 2?
In "Server Configuration Manager", I see DTS Server's State is "Stopped", and Start Mode is "Other (Boot, System, Disabled or Unknown). Attempts to start (by doing: properties -> start) have failed.
In the tool "SQL Server 2005 Surface Area Configuration", I found the "start, stop, pause, resume" buttons grayed out.
david
SQL Server Agent depenedent services which means you have to install SQL Server Agent with a service account. Hope this helps.|||
Are DTS funcationality available for use from ASP.NET 2.0 Beta 2?|||The new the DTS is a full ETL(extraction transforamtion and loading) tool so you have to go to the first link I gave you to know more about it. Another option is the SQL Server BOL(books online) it is the best in the industry. Hope this helps
Can someone tell me how to start DTS Server in SQL 2005 beta 2?
In "Server Configuration Manager", I see DTS Server's State is "Stopped", and Start Mode is "Other (Boot, System, Disabled or Unknown). Attempts to start (by doing: properties -> start) have failed.
In the tool "SQL Server 2005 Surface Area Configuration", I found the "start, stop, pause, resume" buttons grayed out.
david
SQL Server Agent depenedent services which means you have to install SQL Server Agent with a service account. Hope this helps.|||
Thanks for the fast response.
But, could you give me a little walkthrough for doing what you've suggested, namely:
" ... install SQL Server Agent with a service account ... " ?
With beta 2, I can see the tool MS SQL Server Management Studio, and I can see "SQL Server Agent", and in the "Logins" section a number of entries are listed.
But exactly what need to be done to get DTS started? (Pl outline the exact steps - I do not have prior exprience with SQL server admin, and the SQL2005 beta 2 documentation on system admin is mostly "blank" presently.)
Thanks.
david
You need Admin experience to know how to install the SQL Server Agent with a service account most COM C++ programmers need it so they know. That said the quick and dirty solution is to reinstall SQL Server because after six years Microsoft installer now ask you to install SQL Server Agent with a service account. The other option try the links below for the configuration steps. Hope this helps.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_4jxo.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_8sdm.asp
|||Thanks for the detail info you've provided. I am going see what I can do with it. The codes in the links have syntax that resembles what I have seen in some stored procedures (EXEC, ... etc.) Since these are all new to me, I will ask you these 2 elementary questions:
(i) Using just SQL server (i.e. without using ASP.NET), what are some of the ways I may enter and run the sample codes in the links you've provided?
(ii) Assuming DTS is set up successfully and is running, where may I initiate the DTS function in SQL Server 2005?
I know the answer for SQL 2000, and that is simply by going to: Tool -> DTS, or alternately go to Tools -> Import/Export.
For SQL SERVER 2005, should I expect to be able to do the same to start up DTS?
The reason I am asking this is because I have somehow got DTS Server running, but I don't see a way to begin using DTS (I don't see DTS under the "Tools" tab)
Thanks again, for the previous rensponse.
David
Are DTS funcationality available for use from ASP.NET 2.0 Beta 2?|||The new the DTS is a full ETL(extraction transforamtion and loading) tool so you have to go to the first link I gave you to know more about it. Another option is the SQL Server BOL(books online) it is the best in the industry. Hope this helps
Subscribe to:
Posts (Atom)