did anyone have problems setting

tap-mssql

up?

This might help: https://github.com/pymssql/pymssql/issues/769#issuecomment-1404743638

indeed, it works with 3.10.11 - thank you @edgar_ramirez_mondragon

Hello ! I have a similar issue I have created a virtual environment with pyenv and python 3.10.13.

pyenv virtualenv 3.10.13 meltano-virtualenv
pyenv local meltano-virtualenv

Then I have installed meltano :

pip install meltano

and a meltano project :

meltano init meltano-project

In the folder meltano-project, I have created an extractor tap-mssql :

meltano add extractor tap-mssql

and a loader target-mssql :

meltano add loader target-mssql

Issue : when I run

meltano run tap-mssql target-mssql

I get the following error message

Run invocation could not be completed as block failed: Cannot start plugin tap-mssql: Catalog discovery failed: command ['/Users/lucie/Documents/Projets/data_engineering/meltano-project/.meltano/extractors/tap-mssql/venv/bin/tap-mssql', '--config', '/Users/lucie/Documents/Projets/data_engineering/meltano-project/.meltano/run/tap-mssql/tap.9a7a3bed-488c-48de-98e6-631d73fe11c1.config.json', '--discover'] returned 1 with stderr:
 Traceback (most recent call last):
  File "/Users/lucie/Documents/Projets/data_engineering/meltano-project/.meltano/extractors/tap-mssql/venv/bin/tap-mssql", line 5, in <module>
    from tap_mssql.__init__ import main
  File "/Users/lucie/Documents/Projets/data_engineering/meltano-project/.meltano/extractors/tap-mssql/venv/lib/python3.11/site-packages/tap_mssql/__init__.py", line 15, in <module>
    import tap_mssql.sync_strategies.common as common
  File "/Users/lucie/Documents/Projets/data_engineering/meltano-project/.meltano/extractors/tap-mssql/venv/lib/python3.11/site-packages/tap_mssql/sync_strategies/common.py", line 13, in <module>
    from tap_mssql.connection import ResultIterator
  File "/Users/lucie/Documents/Projets/data_engineering/meltano-project/.meltano/extractors/tap-mssql/venv/lib/python3.11/site-packages/tap_mssql/connection.py", line 4, in <module>
    import pymssql
  File "/Users/lucie/Documents/Projets/data_engineering/meltano-project/.meltano/extractors/tap-mssql/venv/lib/python3.11/site-packages/pymssql/__init__.py", line 3, in <module>
    from ._pymssql import *
  File "src/pymssql/_pymssql.pyx", line 1, in init pymssql._pymssql
ImportError: dlopen(/Users/lucie/Documents/Projets/data_engineering/meltano-project/.meltano/extractors/tap-mssql/venv/lib/python3.11/site-packages/pymssql/_mssql.cpython-311-darwin.so, 0x0002): symbol not found in flat namespace '_bcp_batch'

Why does meltano use python3.11 in a virtual environment 3.10 ? Why do I get an issue related to python 3.11 when I am in a virtual environment with python 3.10 ?

Hi @Lucie Martin! I'd try to check with

which pip

before running

pip install meltano

to confirm that pip's using the right python executable