I think you should check Books Online to look at how the packages are stored and the different methods of storage, then you can be confident of calling the correct...

I would try two basic steps from here...

1) Run the job manually and check results

2) Execute the pacakge manually (making sure you are executing the same job package that is...

Usually I find better information in the log message in the Job History one step lower than where your message appears. What does that log message say?

It's pretty much not limited to SQL either.

In my past experience, any effort made to dig in and solve problems, even obscure ones does get recognised by co-workers and management...

Thanks. Logical answer. Could anything else account for it (without direct manipulation)?

Has anybody come across issues of the identity function in T-Sql (using IDENTITY(1,1) I guess) not producing sequential entries. This was one of the reasons (I have been told) for...

Thanks for the comments Guys, it just didn't feel right to me, and I know I can be a stubborn pain at times if I haven't got clarity on something.

I...

I wished I had listened to a SQL DBA about 4 years ago. I was doing 3rd Level Support for 800 Woolworths UK stores including SQL Support for 800 instances...

It's simply called 'DBA Best Practices', funnily enough the author is one Brad McGehee, his name occasionally(?) appears on these forums and at the top of the page.

There is an excellent EBook available for download called 'DBA Best Practices', sounds just what you are looking for. I downloaded it AFTER I got through the interviews recently and...

danielmonro (3/19/2009)

---

It keeps giving me an error message stating that the file cannot be copied because it is in use by another user but Ive searched everywhere and can not...