Post reply

Using script to execute Python script?

  • March 12, 2009 at 12:48 pm

    #128960

    Hi Folks,

    I am trying to simplify a multi-step process whereby data from our GIS SDE database is transformed and loaded into a SQL db.

    The first step in this process is to perform a spatial intersect. I am doing this via a python script on one of our SDE servers. The result of the intersect is a dataset which I then query and transform and ultimately load into another SQL db via an SSIS package.

    So my question is: is there any way to execute the python script from within the SSIS Package? Currently the python script runs via windows task scheduler and then the SSIS package runs about an hour afterward. I would like to combine the two into "one schedule" if possible.

    Thanks,

    Nick

  • March 13, 2009 at 7:38 am

    #959096

    Nick (3/12/2009)

    Hi Folks,

    I am trying to simplify a multi-step process whereby data from our GIS SDE database is transformed and loaded into a SQL db.

    The first step in this process is to perform a spatial intersect. I am doing this via a python script on one of our SDE servers. The result of the intersect is a dataset which I then query and transform and ultimately load into another SQL db via an SSIS package.

    So my question is: is there any way to execute the python script from within the SSIS Package? Currently the python script runs via windows task scheduler and then the SSIS package runs about an hour afterward. I would like to combine the two into "one schedule" if possible.

    Thanks,

    Nick

    You have Execute Process Task in SSIS. Have you tried using it?

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

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

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