If your package is saved to sql server msdb rather than file system then you can make life simple and set "Rely on server security" rather than Encrypt sensitive or...

Likewise about 5 hours and I'm probably one of the most productive in this office. Fridays are the most distractive as everyone is winding down for the weekend- right now...

As well as being a developer I have a number of bought-in packages to DBA and they all use dumb database designs despite only being available with SQL Server database...

Much of my spam invites me to do the physically impossible and enlarge an organ I don't have:D

I use Mailwasher to preview and delete which catches almost everything but some...

In the UK financial advisers are regulated by the Financial Services Authority and there are two types - those who charge the customer and are independant and those who don't...

I too dislike the arrogance of those who post a simple question which could be solved by a quick google or BOL and demand an answer but it would be...

There's a lot of frustration around that we can't do much about the financial situation and it all looks gloomy. One suggestion for the next weekend - grab a...

The recession (whatever the official definition, I believe we're in one) is hitting our household - out of 3 adults, I'm currently the only earner. My son's new to the...

Integration services is what it says - a service running only once on the server. So you don't have a named instance and if you have two instances of 2005...

Execute SQL task is there - you use it in the control flow tab so after your data flow.

If you want to do it after each table then you need...

In the UK we have enough unions to cover the situation - I have a choice of joining two here and we have a union rep in our department. And...

Certainly one solution with common datasources and I'd probably do one package and split up with sequence containers for related tasks eg clear table then fill it.

Don't forget script tasks...

Dinghy sailing with racing weekends and one eveining a week in summer.

No, don't think sitting there on a big boat with the G&T, this is Olympic stuff - a...

It is much easier to take a career break these days as things are changing far less rapidly - we are on the flattening out of the exponential development curve...

Agree with the above - if you don't want it to be public don't advertise it.

But then I'm not sad enough to have time for these social networking sites...