Post reply

Executing a Link?

  • September 24, 2010 at 8:43 am

    #224307

    Long story short - I have server that's not allowed to write directly to MS Dynamis for security reasons. But I do have a business requirement to do so.

    Dynamics has the ability to create records using a web link where the data is inserted into a link then executed - and the data is correctly inserted into MS Dynamics.

    My question is - is there a way to leverage this with SSIS 2005? If so, how would I go about implementing it?

  • September 24, 2010 at 2:01 pm

    #1227220

    You may be able to use the HTTP Connection Manager - see this article:

    http://www.sqlis.com/post/Downloading-a-file-over-HTTP-the-SSIS-way.aspx

    or perhaps a Script Task that uses the .Net WebClient

  • September 28, 2010 at 7:18 am

    #1228321

    bump

  • September 28, 2010 at 7:28 am

    #1228332

    rjames-833409 (9/28/2010)

    bump

    Did you check out the HTTP Connection Manager and, if so, what were your findings?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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