Almost everyone in our business from the spanner turners on the shop floor to the help desk to the managers clocks in and out with a swipe card and we...

Reporting services working with cubes and browsing them. We had to keep COGNOS for a few users when we switched from Oracle recently as SSRS couldn't do the job with...

The configuration details can be altered when setting up the SQL Agent job. When creating the job step select the SQL Server Integration Services package for Type and you get...

I enjoy travel too though for most of mine I'm a snail taking a house with me - my camper van, which means familiar surroundings and comforts in unfamiliar places....

Don't move to the basement Steve. Being able to glance out of the window and see trees and greenery is a contributing factor to office comfort and tranquility.

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...