• Samuel Vella (12/10/2009)


    Personally, I find using windows scheduling and invoking the SSIS package from a .bat file to be a lot more dependable.

    To each his own. I prefer using SQL Server's scheduler because it has better logging and troubleshooting features. In fact if I have a non-SQL-based scheduled job to run on a server that has a SQL server, I'll often use it's scheduler so I can track it in my SQL job tracking system.