• Hi again,

    I'm not sure I quite follow the flow - do you have to pass the parameters via a stored procedure (assuming they are in the textfile)? Couldn't your package grab the variables itself?

    This is not really my domain and I am sure there are other people "out there" with more valuable input!

    In case you are still interested, here is a step by step on how to run a package as a scheduled job:

    http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx

    Sorry I can't be of more help!

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei