SSIS : Load Data From Google Analytics Using Python to SQL Server

Question

Hi All!

I'm struggling with loading data from Google Analytics using Python script to SQL Server in SSIS.
My company doesn't allow any third party tool and my project only goes for On-Premise, so Azure Cloud can't be used.

Now I have complete Python script file, so what I need is, store dataframe from Python code temporaily and finally store it in SQL Server.
Any idea would be helpful to me.

Thanks in advance.

Jamie

Answer 1

Hi @Anonymous ,

I'm not familiar with Python script, but someone mentioned that you may use Execute Process Task to run the code.

Here is a tutorial you may take a reference to.

Executing Python/R Scripts using Microsoft SSIS

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.