It sounds like the account that runs it as a job (the sql agent service account) does not have permission to access the MyServer MyDB database.

You need to give it...

I keep my config file on the same server as the packages run on though I store those packages in msdb.

The account that is defined in the sql agent...

I have always kep Visio diagrams of our databases as part of the systems documentation, using the reverse engineering feature of Visio to create them.

However Microsoft have ruined Visio...

I ticked 4 boxes to cover my job. DBA for both development and production, SSxS developer and ASP.NET developer

That's this month - in a month or two it could be...

Thanks all, especially Beatrix and Stuart. Bristol and Bath are readily commutable and Swindon too. Even Southampton isn't really too far. I'll look for the book and peruse the websites....

I posted this about career options a while ago and just my luck, it didn't even make the daily email and hasn't generated a single reply, but now the...

Have you installed the sql server client tools, notably the visual studio shell part because that is what turns ordinary visual studio into the version for sql ssis, ssas and...

Because SSIS (2008) only writes to one system table we decided to write our package logs to flat files on the database server then add a step to import those...

Having worked in a similar small situation and now in a slightly larger but more regulated organisation, I definitely prefer the latter. We aim to cover each other's tasks so...

When you divert records on error (with a red linking line between transformations) then the last two columns available are error code and error column. You can google the error...

As an IT pro and graduate, I've been involved in the recruitment of programmers and the very first requirement on the job spec. is a degree or HND or equivalent...

If copying a scheduled job, delete the line that begins "@schedule_uid= " and the preceeding comma as it can't create two schedules with the same id.

If it's for backups, have...

It works both ways - my job title is DBA but as well as managing the backups/restores, databases and security and query tuning etcI also do BI development, loads of...

Could you try getting management help to introduce some new tools or even just new tricks for the devs with the selling pitch that these are going to speed up...

I was doing some tuning on a database a couple of days ago and added indexes as there were none. Came back the next day and they'd vanished!

The developers'...