Post reply

Automate SQL DTS job / package from unbound Access Project

  • May 31, 2005 at 4:33 pm

    #68000

    Hi, I have an access project .adp file that connects to an inhouse SQL db backend using unbound forms and strored procedures.

    On one of the forms users can edit Media Releases for their website. Each night SQL DTS runs a job/package that transfers the latest data up to the external website. I also have a SQL Job/package that allows that data to be run manually from Enterprise Manager.

    What I need to do is put a button on the Access Project form that once users added a new Media Release that is urgent for public release the onClick event runs the SQL DTS job/package to upload the new media releases data to the external websites SQL db.

    I know how to run update stored procs from an Access form to do tasks within that inhouse database and another SQL db but not how to call and run a SQL DTS Job or package to move data externally.

    Any ideas or links? Thanks

  • June 2, 2005 at 2:12 pm

    #562715

    You might be able to use the utility rundtsui.exe to generate a string that will run the DTS package from a cmd(Batch) file. Then use the shell command in your code to shell out and run the command file. The best documentation on the dtsrunui.exe is in SQL Server 2000 DTS Step By Step. You run the exe from the start Run Command then select the server and package and it will generate the string, look under the advanced button and copy the string it generates.

     

    Stuart

     

  • June 2, 2005 at 4:00 pm

    #562740

    Thanks for the info.

    Alos of interest is this article that someone sent me on the topic.

    http://www.sqldts.com/default.aspx?208

     

    Thanks again

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

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