Because having an exectuble / code call a job that looks up a package in a table and calls a package...

a) Is like asking the guy on your left to...

If I saw someone use SQL server for tracking data for a MMOG (masively multiplayer online game) like SIMS or World of Warcraft, that would impress me. I know...

UMG Developer (3/16/2009)

Jonathan Kehayias (3/13/2009)

The correct way to do this is to create a SQL Agent Job that runs the SSIS/DTS package, and then start that job using sp_start_job. ...

I agree that there is more to being good at a job than just your raw skills - 'soft skills' are just as important.

What drives me up the wall is...