Post reply

SSIS : How to get the IP Address of the Machine where package is running

  • July 19, 2010 at 3:43 pm

    #224991

    I am inserting records into a table(destination) which has a column called IP address. Is there any chance by using any system variables or any work around to get the ip address of the machine I am running the package on ?? so that I can map system variable/parameter for that column. I am basically working on some Etl logging. So I need to insert IP address of the box .

    Any help would be appreciated..

    Regards

    ashy..

  • July 19, 2010 at 4:00 pm

    #1195183

    query sys.dm_exec_connections for client_net_address. Pull the IP address from that column for your current connection (@@spid).

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 21, 2010 at 8:16 pm

    #1196599

    Check here for programming sample how to get current machine IP address. You can easily convert this into SSIS script.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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