DSXchange

So what actually made you decide you need multiple servers? Was it the data frequency , volume etc , how did you approach to get more? Any feedbacks , pointers?

kduke wrote:We have multiple servers. The ODS is considered critical so it has its own server now. I wish we had a grid instead.

Any Inputs at all?

No one has more than one server for ETL at the client location?

Thanks
Deepak

Hey All , In one of our clients implementations of customized Data warehouse / integration , we have kind of reached a level where every half an hour there is some or the other ETL running and populating the Database. Also its shared with other teams and hence we have other ETLs as well running on t...

1. Try to reset the job and see if that shows an error.

2. Go to the Job Control Tab in the Job Properties and see if there is a wait in there. Not sure if there is an option somewhere in the job to skip it or not , but that will give you an idea.

Thanks !