• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

DTS job is excuting without any data loading

Expert,

I have one DTS job is excuting job, I select DTS data loading query, there is no data files loading b/c the processed_flag is Z, whenever query where clause is processed_flag = Z, it will tell you how many data records loading and which files but if no any output data that means none of data files loading, but I don't understand why this DTS job is excuting. When I refresh job, excuting still is there.  This DTS job suppose run this morning at 4:50 am, but from job history, last run still is from yesterday. so this morning the DTS didn't run. I am not sure if this morning 4:50am do not have job run history, it is because no day needs to load or something run cuased DTS could not run at 4:50am.

Can you give me a help?
0
yrcdba7
Asked:
yrcdba7
  • 5
  • 3
  • 2
1 Solution
 
yrcdba7Author Commented:
Expert,

I ran the DTS package manually from  local Packages. the windows poped out that it is successful.
I look at DTS log, I could see Excel file is not run and other files not run. please see attached file.
Is this because I don't have excel file in the table with processed_flad with Z?

0
 
James MurrellProduct SpecialistCommented:
no attachment
0
 
yrcdba7Author Commented:

Experts,

This DTS has excuted since Feb 9 until Feb 11. It still is excuting.  I have checked if we have data loading no, it is 0 record loading. I have refreshed job, but the status still is excuting.

Can you help ?
DTS-excuted-forever.bmp
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
Anthony PerkinsCommented:
The DTS Package has completed.  Try clicking "Done"
0
 
James MurrellProduct SpecialistCommented:
Have to agree with acperkins there, or double click on the error one and see what it message says
0
 
yrcdba7Author Commented:


Expert,
After DTS job ran I have click DONE button, the job status Excuting still there.
I also saw the error from DTS package running steps, here is the error.
step transform data task EXCEL2SQL,  error occurred (356)
Please see attached files.

Thank you,

YRChen
DTS-error-021209-1.bmp
DTS-error-021209-2.bmp
DTS-error-021209-3.bmp
DTS-error-021209-5.bmp
0
 
yrcdba7Author Commented:

Does any experts can give me this help, URGENT!
Thank you,
0
 
James MurrellProduct SpecialistCommented:
EXCEL2SQL is a third party product........ i have never used it can you contact them
0
 
Anthony PerkinsCommented:
I am afraid I have no idea.
0
 
yrcdba7Author Commented:
Today DTS did not run this morning even we have more than ten files are waiting for loading.
I have to do the manually run. Before I manually ran the DTS job, I could see the job status was excuting step... so it was the same before.  I still do not know how to let the job status go back to suceed or failed message but not always excuting step...

any help?

0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 5
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now