Solved

ETL package fails when run as a schedule job - works fine if run manually

Posted on 2013-12-18
2
484 Views
Last Modified: 2013-12-18
I have a scheduled ETL package that has run for many years every night without an issue.  Suddenly it has started to fail every night.  I can still run it manually and it completes successfully.  I thought maybe the job was corrupt so recreated it but that new job also fails.  I am not finding any details on the job history - just the history that it fails on step 1 (and there is only 1 step that is very long).  This package rebuilds our data warehouse.  I'm not sure how to troubleshoot this.
0
Comment
Question by:cindyfiller
2 Comments
 
LVL 10

Accepted Solution

by:
PadawanDBA earned 500 total points
ID: 39726800
Are there any errors in the windows and/or sql server event log(s) that correspond to the time of execution on the automated run?
0
 

Author Comment

by:cindyfiller
ID: 39727104
I didn't realize that it logged each portion of the ETL package out in the event viewer.  I see what module is failing - which I didn't know before.  That helps tremendously.  Now I can focus on that.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question