Databases
StackOverflow2013
Postsdbo
POSSIS: Execute Ironpython or Ironruby scripts through SSIS
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSSIS: Execute Ironpython or Ironruby scripts through SSIS
    primarykey
    data
    text
    <h2>Problem!</h2> <p>I have a little python script, which goes throught a web page (http-crawling). This web-page is hosted inside the intranet and uses NTLM authentication to gather access to it. </p> <p>So, I found this task (retrieve http-content) easily programmable using python, instead of trying to re-write the whole python script to C# and then use it througth "Script Task" on SSIS, in order to complete the task.</p> <h2>Hint!</h2> <p>I've looked up closely to SSIS tools and I found that there is a Control Flow named "Execute Process Task", which lets you to execute Win32 executables.</p> <p>But the problem resides in how to call my python script since it's not executable and needs to be interpreted by the python interpreter (if you'll forgive the repetition). So, I could easily end up building a simple ".bat" file that calls both the python script and the interpreter. And then execute that file through SSIS "Execute Process Task".</p> <h2>Question!</h2> <p>Is there any other way to implement this? (neat way)</p> <h1>Edit #1</h1> <h2>Usage</h2> <p>The information retrieved from the script will be storing that information into a table from a database, So that information will be accessed trough the database table from another SSIS process. </p> <p>I'm retrieving the information from different sources (flat files, database tables, http request, ...) in order to archive that information into a database that could be posted in a web services and then accessed from a Excel project.</p> <p>Thanks in Advance!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USEder
    1. USEder
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSSIS: Execute Ironpython or Ironruby scripts through SSIS
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSSIS: Execute Ironpython or Ironruby scripts through SSIS
      1. USEder
      1. VTBountyStart
    3. VO
      singulars
      1. POSSIS: Execute Ironpython or Ironruby scripts through SSIS
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYou didn't specify what you wanted to do with the results of your python script. Are you simply using SSIS as a timing mechanism?
      singulars
      1. POSSIS: Execute Ironpython or Ironruby scripts through SSIS
      1. USRex Whitten
    2. COIt's been some time, but what do you mean the script isn't executable? Doesn't `python myscript.py` work? Also, if it's an Iron* variant, you could probably invoke it from a Script task. Probably need to bump the .NET level of the project up from 2.0 but I think it should work based on my half-understood followings of the IronPython mailing list.
      singulars
      1. POSSIS: Execute Ironpython or Ironruby scripts through SSIS
      1. USbillinkc
    3. CO@billinkc: As I commented in the post, it is possible to call the script that Way via Execute Process Task but I'm looking for a more efficient way of doing it so I can interact ironpython code with SSIS?
      singulars
      1. POSSIS: Execute Ironpython or Ironruby scripts through SSIS
      1. USEder
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload