Post reply

Execute a SSIS package from VB or a stored procedure

  • August 1, 2006 at 1:49 pm

    #115940

    How can I run a SSIS package from a Access form with VB or from a stored procedure in sql server 2005?

  • August 2, 2006 at 4:53 am

    #652774

    a couple of ideas for the stored procedure:

    1: Create an agent job that runs the task. Then have an SP that invokes sp_start_job to run the job

    2: (ugly!) use xp_cmdshell to invoke the package using the DTEXEC commandline interface

    ...

    I've not yet found a sp_(run/startexec)_Package ... ther may be one... That would be the best method, if it is a 'open' SP (i.e not one of MS's hidden SP's).

    HTH

  • August 15, 2006 at 3:01 pm

    #655154

    were you able to get this to work?

  • August 15, 2006 at 3:15 pm

    #655160

    The server I am working on has the SSIS tools loaded but not the SSIS package itself.  Neither of the methods will work until that is fixed.  I will use the "BULK INSERT" T-SQL command instead since I cannot control what is on the clients server.

     

  • August 15, 2006 at 3:28 pm

    #655165

    Ok,

    I was able to get it to work.

    Thanks Wanderer!

     

  • August 16, 2006 at 3:04 am

    #655217

    glad they were able to help 🙂

  • September 20, 2007 at 3:39 am

    #734869

    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:11 am

    #734875

    Why do you hijack this thread as well as posting the question in two other threads???

    Ignore this: asked and answered in another thread.

    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!

  • September 20, 2007 at 5:11 am

    #734885

    thanks for clarifying that, Crispin.

     

    by the way - how's life? Where are you these days? (wanderer @ sqlservercentral = wanderer @ sqlteam )

Viewing 9 posts - 1 through 8 (of 8 total)

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