Python to SQL Server - SSIS Part 1

[karanmthevar]

transferring data from excel to the hell is python used this guy

[taiphan]

I run fine in SSIS with python simple python scripts. but when i use import pyodbc on the script file it gave me an error with

[Execute Process Task] Error: In Executing "C:\Program Files (x86)\Python39-32\python.exe" "LoadingScripts.py" at "D:\MyDir\Testprocess", The process exit code was "1" while the expected was "0".


here is my script file
import sys, os
import pyodbc

print("Testd")