DTS Failed To Run

Hi all,

I have almost 50 DTS and its was scheduled run daily at a specific
time. Since last week all the jobs was failed. Error "The process could
not be created for step 1 of job 0x43434..... (reason : The system
cannot find the file specified). The step failed.". The jobs was run
find before. If I manually execute package under Local Package it ok.
I'm not a DBA. Any help are welcome.Find the solution under and it work now.
http://support.microsoft.com/kb/322746/en-ussql

DTS Failed

SQL 2K
We have a job to run a DTS which loads and computes data from a database in
the same server..
This jobs worked till yesterday, failed today with error message
Executed as user: MyDomain\Myuser. ...: DTSStep_DTSExecuteSQLTask_11
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_11 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_7 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_7
DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart:
DTSStep_DTSDataPumpTask_2 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1;
1000 Rows have been transformed or copied.; PercentComplete = 0;
ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000
Rows have been transformed or copied.; PercentComplete = 0; ProgressCount =
2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3000 Rows have been
transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun
OnProgress: DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or
copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress:
DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = ... Process Exit Code 1. The step
failed.
No changes made to server or job..
Looked at the server Event viewer , found nothing ..
Any thoughts ?
S
I'm guessing this is the output from the job history. The job history ouput
only show part of the DTS log, so you may be missing the critical
information you need to help you debug this problem. Did you output the
entire DTS output to a file with either the advanced tab option when editing
the job step or the dtsrun /L option? If so look at the log file, in there
and you might find additional information. If not modify your job to create
the log file and rerun.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"MS User" <sqlman@.sql.com> wrote in message
news:uHOlG$eMEHA.1188@.TK2MSFTNGP12.phx.gbl...
> SQL 2K
> We have a job to run a DTS which loads and computes data from a database
in
> the same server..
> This jobs worked till yesterday, failed today with error message
> Executed as user: MyDomain\Myuser. ...: DTSStep_DTSExecuteSQLTask_11
> DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_11 DTSRun OnStart:
> DTSStep_DTSExecuteSQLTask_7 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_7
> DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart:
> DTSStep_DTSDataPumpTask_2 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1;
> 1000 Rows have been transformed or copied.; PercentComplete = 0;
> ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000
> Rows have been transformed or copied.; PercentComplete = 0; ProgressCount
=
> 2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3000 Rows have been
> transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun
> OnProgress: DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or
> copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress:
> DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed or copied.;
> PercentComplete = 0; ProgressCount = ... Process Exit Code 1. The step
> failed.
> No changes made to server or job..
> Looked at the server Event viewer , found nothing ..
> Any thoughts ?
> S
>

DTS Failed

SQL 2K
We have a job to run a DTS which loads and computes data from a database in
the same server..
This jobs worked till yesterday, failed today with error message
Executed as user: MyDomain\Myuser. ...: DTSStep_DTSExecuteSQLTask_11
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_11 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_7 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_7
DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart:
DTSStep_DTSDataPumpTask_2 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1;
1000 Rows have been transformed or copied.; PercentComplete = 0;
ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000
Rows have been transformed or copied.; PercentComplete = 0; ProgressCount =
2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3000 Rows have been
transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun
OnProgress: DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or
copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress:
DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = ... Process Exit Code 1. The step
failed.
No changes made to server or job..
Looked at the server Event viewer , found nothing ..
Any thoughts '
SI'm guessing this is the output from the job history. The job history ouput
only show part of the DTS log, so you may be missing the critical
information you need to help you debug this problem. Did you output the
entire DTS output to a file with either the advanced tab option when editing
the job step or the dtsrun /L option? If so look at the log file, in there
and you might find additional information. If not modify your job to create
the log file and rerun.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"MS User" <sqlman@.sql.com> wrote in message
news:uHOlG$eMEHA.1188@.TK2MSFTNGP12.phx.gbl...
> SQL 2K
> We have a job to run a DTS which loads and computes data from a database
in
> the same server..
> This jobs worked till yesterday, failed today with error message
> Executed as user: MyDomain\Myuser. ...: DTSStep_DTSExecuteSQLTask_11
> DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_11 DTSRun OnStart:
> DTSStep_DTSExecuteSQLTask_7 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_7en">
> DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart:
> DTSStep_DTSDataPumpTask_2 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1;
> 1000 Rows have been transformed or copied.; PercentComplete = 0;
> ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000
> Rows have been transformed or copied.; PercentComplete = 0; ProgressCount
=
> 2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3000 Rows have been
> transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun
> OnProgress: DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or
> copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress:
> DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed or copied.;
> PercentComplete = 0; ProgressCount = ... Process Exit Code 1. The step
> failed.
> No changes made to server or job..
> Looked at the server Event viewer , found nothing ..
> Any thoughts '
> S
>

DTS Failed

SQL 2K
We have a job to run a DTS which loads and computes data from a database in
the same server..
This jobs worked till yesterday, failed today with error message
Executed as user: MyDomain\Myuser. ...: DTSStep_DTSExecuteSQLTask_11
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_11 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_7 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_7
DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart:
DTSStep_DTSDataPumpTask_2 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1;
1000 Rows have been transformed or copied.; PercentComplete = 0;
ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000
Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3000 Rows have been
transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun
OnProgress: DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or
copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress:
DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = ... Process Exit Code 1. The step
failed.
No changes made to server or job..
Looked at the server Event viewer , found nothing ..
Any thoughts '
SI'm guessing this is the output from the job history. The job history ouput
only show part of the DTS log, so you may be missing the critical
information you need to help you debug this problem. Did you output the
entire DTS output to a file with either the advanced tab option when editing
the job step or the dtsrun /L option? If so look at the log file, in there
and you might find additional information. If not modify your job to create
the log file and rerun.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"MS User" <sqlman@.sql.com> wrote in message
news:uHOlG$eMEHA.1188@.TK2MSFTNGP12.phx.gbl...
> SQL 2K
> We have a job to run a DTS which loads and computes data from a database
in
> the same server..
> This jobs worked till yesterday, failed today with error message
> Executed as user: MyDomain\Myuser. ...: DTSStep_DTSExecuteSQLTask_11
> DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_11 DTSRun OnStart:
> DTSStep_DTSExecuteSQLTask_7 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_7
> DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart:
> DTSStep_DTSDataPumpTask_2 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1;
> 1000 Rows have been transformed or copied.; PercentComplete = 0;
> ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000
> Rows have been transformed or copied.; PercentComplete = 0; ProgressCount
=> 2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3000 Rows have been
> transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun
> OnProgress: DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or
> copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress:
> DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed or copied.;
> PercentComplete = 0; ProgressCount = ... Process Exit Code 1. The step
> failed.
> No changes made to server or job..
> Looked at the server Event viewer , found nothing ..
> Any thoughts '
> S
>

DTS 2000 on 64 Bit

Hi,

I have certain DTS 2000 jobs which have to br run on a 64 bit system after upgradation. Is this possible

Manish

Moving to the IS forum, where you're more likely to get a response.

Paul

|||

yes, I suggest reading from the following topic from SQL Books Online.

"Integration Services Considerations on 64-bit Computers "

DTS 2000 on 64 Bit

Hi,

I have certain DTS 2000 jobs which have to br run on a 64 bit system after upgradation. Is this possible

Manish

Moving to the IS forum, where you're more likely to get a response.

Paul

|||

yes, I suggest reading from the following topic from SQL Books Online.

"Integration Services Considerations on 64-bit Computers "

DTS 2000 not running in SQL Server 2005

I'm having a problem running a legacy DTS in SQL 2005. I've installed the
Feb 2007 feature pack and my DTS jobs still are not working. I open package
and click start, the package runs for a few moments and then abruptly closes
Management Studio. I've tried running this from SQL Agent and it still
failes.
The package was created with the BI accelerator.
Thanks,
--
RonHi Ron
Have you run SQL profiler against it to see what is happening? If this uses
a third party component has his been installed correcly?
John
"Ron" wrote:
> I'm having a problem running a legacy DTS in SQL 2005. I've installed the
> Feb 2007 feature pack and my DTS jobs still are not working. I open package
> and click start, the package runs for a few moments and then abruptly closes
> Management Studio. I've tried running this from SQL Agent and it still
> failes.
> The package was created with the BI accelerator.
> Thanks,
> --
> Ron|||John,
Thanks for the reply. Actually the BI Accelerator is/was a Microsoft
Application (Microsoft Accelerator for BI), but I believe it's been retired.
I think the issue was with the compatibility level of my DB's. I had them
set to 80 instead of 90. I'm going to do a bit more testing, but I hope that
was the problem.
If you can think of anything else I should check please let me know.
Thanks,
--
Ron
"John Bell" wrote:
> Hi Ron
> Have you run SQL profiler against it to see what is happening? If this uses
> a third party component has his been installed correcly?
> John
> "Ron" wrote:
> > I'm having a problem running a legacy DTS in SQL 2005. I've installed the
> > Feb 2007 feature pack and my DTS jobs still are not working. I open package
> > and click start, the package runs for a few moments and then abruptly closes
> > Management Studio. I've tried running this from SQL Agent and it still
> > failes.
> >
> > The package was created with the BI accelerator.
> >
> > Thanks,
> > --
> > Ron

Dts . .

Hi Frnds,

Will anyone plz give me the intro about the DTS nd Sql Batch Jobs.

Thnx & Regards

(M. Nedu . .)1.Go to SQL Server Enterprise Manager
2.In desired database find Data Transformation Services
3.Find Local Packages. Right-Click and select New Package.
4.Play with different options for example you can execute some stored procedures or scripts or do multiple tasks one after another (you need some skills to make it work).
5.After work is done and saved you can right click on the package and Schedule Package to run. It will create server job for you.

I am sure it is very little help but jump into the water and swim. Your question is too broad to have definitive answer.

DTS oracle Jobs hang

hello:
My situation is
(1) I upgraded MS SQL 7.0 from original edition to SP 4
(2) DTS packages which download data from an oracle server work fine both on a remote machine and on the Server
(3) When these packages are scheduled to run as jobs they do not succeed and do not fail they just keep running e.g for 58 hours over the weekend
(4) even if I start the job on the server I still get the same behaviour:

Can anyone help please?I have lots of experience with running DTS packages to Oracle, but none in a SQL 7 SP4 environment. These are the things that I would do:

1. Check your application error log; look for any warnings and/or errors that are related to Oracle.
2. Open of SQL*Plus on the server; attempt to connect. Look for any error messages or warnings.
3. Delete and re-initialize the Oracle connection objects in your DTS packages; this can be a pain. Try creating the new connection first and then changing the connection name in the connection objects that are "in the flow".
4. Save the DTS package as a VB file and open (and execute) the package in VB. I dunno if this is an option with SQL 7.0 SP4; it is with 2000.

Sorry, that's not very much to go one for right now. I have seen this issue with AS/400 connections (frequently). It boiled down to an application pop-up window which was not visible when the DTS job ran as a job (but which was visible when executed from the DTS pacakge maintenance window).

Best of luck.

Regards,

hmscott|||Thank you HMScott

I've investigated these and still could'nt find the problem. Then I noticed that the jobs actually work but are not marked as finished. This seems identical to http://www.dbforums.com/t943042.html except that this SQL 7.0 and that was SQL 2000. I still cant get the jobs to mark themselves as finished. ??|||Out of curiousity, where are you seeing that the jobs are not marked "finished". If you are looking at the jobs through the job monitor (under Management/SQL Server Agent/Jobs), are you remembering to periodically refresh the screen (press F5)?

Regards,

hmscott|||I sure do HM (F5 that is) The jobs normally take a minute but when I cancelled them they had been running for 58 hours plus. I'm begining to wonder if it's something to do with the mail client. This machine was also hit by the Lovebug virus which is mail related I believe.

I'm no expert but I was wondering if there was anyway I could get a hint as to whats wrong. I looked in sqlagent.out but could see nothing.
I ran a trace and then started the job. Could'nt see anything obvious but to be honest was a bit lost in there in Trace World.|||Can take help of this KBA (http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074) to schedule dts as a job.

And also this Winnet mag article (http://www.winnetmag.com/Article/ArticleID/14399/Windows_14399.html) for reference.

HTH|||Thanks to all for their input:

Current situation
The jobs are now working.
I went into the Package properties and disabled the "USE OLE DB service components" and now the jobs work and mark themselves as completed. If I enable this then the Oracle jobs wont mark themselves as completed.
This weird as the connection still uses the "Oracle provider for OLE DB"

Nevertheless it is progress

DTS

Hi,

What is good way of executing .dtsx jobs in sql 2005, when stored in file format, or msdb database. Can my sql agent read jobs from file format as well as msdb database ?

Thanks &Regards

Nitu

Yes SQLAgent can execute file system or msdb packages. I'm surprised you could not find that information in Books Online. The online version is here ...

http://msdn2.microsoft.com/en-us/library/ms141701(SQL.90).aspx

At the bottom of every Books Online page there is an option to vote for the usefulness of the content. You can do that to help us improve the content - I'm concerned that you are not finding this information there, so any help you can give us would be appreciated.

Donald Farmer