DTS schedule job fails urgent pls help!

Hi all,

We have created DTS jobs which copies data from one server to another and truncates the destination before copying the data from source. when we run the job manually it runs fine, but when schedule its failing with the below errors.

DTSRun: Loading...DTSRun: Executing...DTSRun
OnStart: DTSStep_DTSExecuteSQLTask_1DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1DTSRun OnStart: Copy Data
from CustomerMaster to
[OUTBOUND].[dbo].[CustomerMaster]
StepDTSRun OnError: Copy Data from CustomerMaster
to [OUTBOUND].[dbo].[CustomerMaster]
Step, Error = -2147008507 (80074005) Error string:
Unspecified error Error source: Microsoft Data
Transformation Services (DTS) Package Help file:
sqldts.hlp Help context: 1100Error Detail
Records:Error: -2147008507 (80074005); Provider
Error: 0 (0) Error string: Unspecified error
Error source: Microsoft Data Transformation Services
(DTS) Package Help file: sqldts.hlp Help context:
1100Error: -2147467259 (80004005); Provider Error:
0 (0) Error string: Timeout expired Error source:
Microsoft OLE DB Provider for SQL Server Help file:
Help context: 0DTSRun OnFinish: Copy Data from
CustomerMaster to
[OUTBOUND].[dbo].[CustomerMaster]
StepDTSRun: Package execution complete.
please suggest to over come this problem.

TIAMy guess is that the DTS job is scheduled to run as a different NT logon than the one you are using to test it interactively. The scheduled logon is probably missing one or more permissions needed for the DTS package.

-PatP

dts migration

Hi,

How to migrate scheduled jobs from 2000 to 2005. Is this possible by doing bcp out and bcp in system tables which stores sql agent jobs from msdb database ?

Regards

Nit

This question is not related to SSIS. I'd try another forum if I were you. https://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1

-Jamie

DTS Jobs Troubles

I'm trying to run DTS packages (import AS400 information) on a job and it fails, but when I program a DTS package job that imports from SQL Server to SQL Server it does not fail.
What can I do?
I hope your answer
Thanks
Cristopher SerratoCheck your connectin string to AS400.
is it a DB2 server ?
Do you have DB2 Connectivity kit installed ?

Originally posted by cjserrato
I'm trying to run DTS packages (import AS400 information) on a job and it fails, but when I program a DTS package job that imports from SQL Server to SQL Server it does not fail.

What can I do?

I hope your answer

Thanks

Cristopher Serrato|||Originally posted by Ben Mansouri
Check your connectin string to AS400.
is it a DB2 server ?
Do you have DB2 Connectivity kit installed ?

I CHECKED MY CONECTION AND IT'S GOOD, EVEN IF I PLAY THE DTS PACKAGE, IT WORKS BUT WHEN I PUT IT INTO A JOB IT FAILS.

I DOWNLOADED THE SERVICE PACK 3A, BUT IT DOES NOT WORK YET.

WHAT COULD IT BE SO?|||Take help from this KBA (http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074) to schedule a DTS package.|||Is there any transformation envolved on DTS ?

Originally posted by Satya
Take help from this KBA (http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074) to schedule a DTS package.|||Originally posted by Ben Mansouri
Is there any transformation envolved on DTS ?

No, the only one that I got is

AS400 -> SQL SERVER 2000

DTS jobs hang

Hi Experts out there,
I would like to know find out from you, I created a package in SQL 2000 DTS
module. When i execute the package it runs perfectly well. Unfortunately when
I execute it by scheduling, the package will hang there. The status is always
"Executing...step (1)...". Perhaps when I execute manually, it takes less
than 30 seconds to complete...but when I schedule it, it just hang there for
many minutes and it doesn't continue..There is no error message prompt at all.
Can some one please give me some tips on how should I go about scheduling
the package and run successfully.. Many Thanks in advance...
Regards,
Rachael Lim
When you say you run it manually, how do you do this? Where and how are you
logged in? Do you run the job manually or do you load and execute the DTS
package manually?
Sincerely,
Anthony Thomas

"Rachael Lim" <Rachael Lim@.discussions.microsoft.com> wrote in message
news:BB8EB37D-25C1-4F8B-BF87-D5263131B9ED@.microsoft.com...
Hi Experts out there,
I would like to know find out from you, I created a package in SQL 2000 DTS
module. When i execute the package it runs perfectly well. Unfortunately
when
I execute it by scheduling, the package will hang there. The status is
always
"Executing...step (1)...". Perhaps when I execute manually, it takes less
than 30 seconds to complete...but when I schedule it, it just hang there for
many minutes and it doesn't continue..There is no error message prompt at
all.
Can some one please give me some tips on how should I go about scheduling
the package and run successfully.. Many Thanks in advance...
Regards,
Rachael Lim
|||WHen I execute it manually means I am in the design mode of the package and
execute the package.
I created the scheduled job by right-clicing on the package and select
schedule package.
"AnthonyThomas" wrote:

> When you say you run it manually, how do you do this? Where and how are you
> logged in? Do you run the job manually or do you load and execute the DTS
> package manually?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Rachael Lim" <Rachael Lim@.discussions.microsoft.com> wrote in message
> news:BB8EB37D-25C1-4F8B-BF87-D5263131B9ED@.microsoft.com...
> Hi Experts out there,
> I would like to know find out from you, I created a package in SQL 2000 DTS
> module. When i execute the package it runs perfectly well. Unfortunately
> when
> I execute it by scheduling, the package will hang there. The status is
> always
> "Executing...step (1)...". Perhaps when I execute manually, it takes less
> than 30 seconds to complete...but when I schedule it, it just hang there for
> many minutes and it doesn't continue..There is no error message prompt at
> all.
> Can some one please give me some tips on how should I go about scheduling
> the package and run successfully.. Many Thanks in advance...
> Regards,
> Rachael Lim
>
>
|||Enable package level logging and rerun from the scheduled job. If you have
to cancel the job, that's ok. The logging happens at each step within the
package. This will give you more verbose execution state information.
I suspect you have a permissions issue but the logging should help you
determine this.
Keep in mind that the package runs under the permissions of the executor,
not the storage location and from the location of the executor. When you
run, your permissions and your workstation, when the SQL Agent job runs, the
service account that the SQL Agent is running under and from the SS server's
location. This is an important consideration for local drives and maps as
well as installed executibles, like the WSH ActiveX components.
Sincerely,
Anthony Thomas

"Rachael Lim" <RachaelLim@.discussions.microsoft.com> wrote in message
news:95D6E3CD-EDD7-4D01-88AE-213BCE343C7F@.microsoft.com...
WHen I execute it manually means I am in the design mode of the package and
execute the package.
I created the scheduled job by right-clicing on the package and select
schedule package.
"AnthonyThomas" wrote:

> When you say you run it manually, how do you do this? Where and how are
you
> logged in? Do you run the job manually or do you load and execute the DTS
> package manually?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Rachael Lim" <Rachael Lim@.discussions.microsoft.com> wrote in message
> news:BB8EB37D-25C1-4F8B-BF87-D5263131B9ED@.microsoft.com...
> Hi Experts out there,
> I would like to know find out from you, I created a package in SQL 2000
DTS
> module. When i execute the package it runs perfectly well. Unfortunately
> when
> I execute it by scheduling, the package will hang there. The status is
> always
> "Executing...step (1)...". Perhaps when I execute manually, it takes less
> than 30 seconds to complete...but when I schedule it, it just hang there
for
> many minutes and it doesn't continue..There is no error message prompt at
> all.
> Can some one please give me some tips on how should I go about scheduling
> the package and run successfully.. Many Thanks in advance...
> Regards,
> Rachael Lim
>
>

DTS jobs hang

Hi Experts out there,
I would like to know find out from you, I created a package in SQL 2000 DTS
module. When i execute the package it runs perfectly well. Unfortunately when
I execute it by scheduling, the package will hang there. The status is always
"Executing...step (1)...". Perhaps when I execute manually, it takes less
than 30 seconds to complete...but when I schedule it, it just hang there for
many minutes and it doesn't continue..There is no error message prompt at all.
Can some one please give me some tips on how should I go about scheduling
the package and run successfully.. Many Thanks in advance...
Regards,
Rachael LimWhen you say you run it manually, how do you do this? Where and how are you
logged in? Do you run the job manually or do you load and execute the DTS
package manually?
Sincerely,
Anthony Thomas
"Rachael Lim" <Rachael Lim@.discussions.microsoft.com> wrote in message
news:BB8EB37D-25C1-4F8B-BF87-D5263131B9ED@.microsoft.com...
Hi Experts out there,
I would like to know find out from you, I created a package in SQL 2000 DTS
module. When i execute the package it runs perfectly well. Unfortunately
when
I execute it by scheduling, the package will hang there. The status is
always
"Executing...step (1)...". Perhaps when I execute manually, it takes less
than 30 seconds to complete...but when I schedule it, it just hang there for
many minutes and it doesn't continue..There is no error message prompt at
all.
Can some one please give me some tips on how should I go about scheduling
the package and run successfully.. Many Thanks in advance...
Regards,
Rachael Lim|||WHen I execute it manually means I am in the design mode of the package and
execute the package.
I created the scheduled job by right-clicing on the package and select
schedule package.
"AnthonyThomas" wrote:
> When you say you run it manually, how do you do this? Where and how are you
> logged in? Do you run the job manually or do you load and execute the DTS
> package manually?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Rachael Lim" <Rachael Lim@.discussions.microsoft.com> wrote in message
> news:BB8EB37D-25C1-4F8B-BF87-D5263131B9ED@.microsoft.com...
> Hi Experts out there,
> I would like to know find out from you, I created a package in SQL 2000 DTS
> module. When i execute the package it runs perfectly well. Unfortunately
> when
> I execute it by scheduling, the package will hang there. The status is
> always
> "Executing...step (1)...". Perhaps when I execute manually, it takes less
> than 30 seconds to complete...but when I schedule it, it just hang there for
> many minutes and it doesn't continue..There is no error message prompt at
> all.
> Can some one please give me some tips on how should I go about scheduling
> the package and run successfully.. Many Thanks in advance...
> Regards,
> Rachael Lim
>
>|||Enable package level logging and rerun from the scheduled job. If you have
to cancel the job, that's ok. The logging happens at each step within the
package. This will give you more verbose execution state information.
I suspect you have a permissions issue but the logging should help you
determine this.
Keep in mind that the package runs under the permissions of the executor,
not the storage location and from the location of the executor. When you
run, your permissions and your workstation, when the SQL Agent job runs, the
service account that the SQL Agent is running under and from the SS server's
location. This is an important consideration for local drives and maps as
well as installed executibles, like the WSH ActiveX components.
Sincerely,
Anthony Thomas
"Rachael Lim" <RachaelLim@.discussions.microsoft.com> wrote in message
news:95D6E3CD-EDD7-4D01-88AE-213BCE343C7F@.microsoft.com...
WHen I execute it manually means I am in the design mode of the package and
execute the package.
I created the scheduled job by right-clicing on the package and select
schedule package.
"AnthonyThomas" wrote:
> When you say you run it manually, how do you do this? Where and how are
you
> logged in? Do you run the job manually or do you load and execute the DTS
> package manually?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Rachael Lim" <Rachael Lim@.discussions.microsoft.com> wrote in message
> news:BB8EB37D-25C1-4F8B-BF87-D5263131B9ED@.microsoft.com...
> Hi Experts out there,
> I would like to know find out from you, I created a package in SQL 2000
DTS
> module. When i execute the package it runs perfectly well. Unfortunately
> when
> I execute it by scheduling, the package will hang there. The status is
> always
> "Executing...step (1)...". Perhaps when I execute manually, it takes less
> than 30 seconds to complete...but when I schedule it, it just hang there
for
> many minutes and it doesn't continue..There is no error message prompt at
> all.
> Can some one please give me some tips on how should I go about scheduling
> the package and run successfully.. Many Thanks in advance...
> Regards,
> Rachael Lim
>
>

DTS Job Urgent

hi,
Sql Server 7

we have various jobs running. one of which copies data from one table on one server to another. recently i found out the job had failed when i went and looked at the history it says
the job failed. the job was invoked by schedule 35.
DTs run:loading.. DTSRun:Executing DTSrunonstart.
DTS on error step erro=-2147217865(80040E37)
error string:invalid object name
error source:microsoft OLE provider to sql server
error:-2147217865

i looked for the package i did not find any for that particular. and when i try to start the job manually it does not have any effect.(tried several times)

pls suggest wht might be the problem.

TIAClick on "Show step details" - Copy and paste the results.

DTS job

Hi,

If my one .dtsx jobs calls another .dtsx jobs, how this situation should be taken care?Please help me out on this.

Regards

Nitu

You should use the ExecutePackage task. See http://msdn2.microsoft.com/en-us/library/ms137609(SQL.90).aspx

Donald Farmer