#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    2
    Rep Power
    0

    DTS Connection to an Exchange Server??


    Hello...

    I'm trying to figure how how to move some data from a SQL database to a calender entry on an exchange server.

    I'd like to set up a trigger on a table so that when data hits that table (from another 3rd pty application) a job is run to move some data to exchange.

    From this microsoft site ( http://msdn.microsoft.com/library/de...basic_71v7.asp ) it appears that a dts package can connect to an exchange server, but I can't seem to find any information on how to create the connection.

    Anyone do anything like this before?

    Thanks!
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    538
    Don't know exactly, for shure you need an OLEDB provider for Exchange.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    2
    Rep Power
    0

    dts to exchange


    Sorry, I havent worked with setting up an exchange connection within tsql before. I will poke around and see if I can find anything, but it really doesnt ring a bell.
    The only thing that comes to mind is setting up your calendar as an operator, and then scheduling a job to update it.

IMN logo majestic logo threadwatch logo seochat tools logo