This is where we come across job responsibilities or separation of duties. Only few selected individuals or a group in an organization must have the ability to change the...

Looks to me like an Excel Driver Issue, this might need 64 bit drivers. Ensure that excel data source settings are correct in SQL Agent Job.
or
Try running the...

Use 
--------
ORDER BY b.CmpntNum Or

ORDER BY Component

CDC is a nice feature to track changes. We have enabled it on one of our primary database on our production server with a retention period of 3 days. We...

Hi,
If possible and if it is not a performance issue, I would advise bring all the data that you need into staging tables first, and then build a VIEW,...

Hi,
Late arriving dimensions are processed in different ways. We have a process were we capture the fact record and keep it separately in a different table and there is...

Can you run the job by using the Service Account that is running the SQL Agent?

I receive emails every time a 500 error occurs on the web server and yesterday I...

AccountName    Level    IsCurrent      Parent

District 1        1             0         ...

Hi,
Looks like you are working with slowly changing dimensions.  An alternate way is to split the MERGE statement into two, INSERT and UPDATE separately.

--Use Merge...

Hi,

ROW_NUMER()  analytical function can be used to generate a new number for each row.

Select t.*, ROW_NUMBER () over (order by sortid)   RowNumber
from #tblTasks...

Hi,
Reduce the Degree of parallelism setting to 2 and give it a try.