Post reply

invoking SSIS package programatically

  • September 20, 2007 at 3:41 am

    #118279

     

    Hi,

    I have a requirement where in i need to keep polling a folder for files and once the file arrives in a folder , i need to invoke ann SSIS package. I don't know how to invoke a package from code.

    I am thinking, i'll make a windows service which will keep polling the folder and will invoke ssis package if some file comes in.

    Somebody please help me out with the code.

    Thanks,

    Tarun

  • September 20, 2007 at 4:09 am

    #734874

    You could have the package watching for the file. See FileWatcher task on http://www.SQLIS.com

    Or you can execute a package through CMD DTEXEC /File "path to dtsxfile" /plenty other options

     

     

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply