• Karen Grube,

    a) You can configure SQL agent to run packages from file system. So if you can place the package in a fileshare and if the sql server agent has access to these files, you can succesfully configure the job.

    b) Another aproach you can use is create an application (.net) to call these packages . schedule this with windows scheduler.

    http://stackoverflow.com/questions/273751/how-to-execute-an-ssis-package-from-net

    I havent tried the second option (I had been a DBA with all access most of my career), but I am confident it should work

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]