invoking SSIS package programatically

• tarun nagpal

  SSC Rookie

  Points: 27

  More actions

  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

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  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!