Anyone got any insight on issue with installation of

target-mssql

?

It looks to me like your issue is with some part of the Meltano install? I am the maintaner of target-mssql, but i haven't seen that issue before. The error message says you are using windows?

Yes. This is what I get when I run

meltano run tap-csv target-mssql

now

2023-12-01T07:34:01.452864Z [warning  ] No state was found, complete import.
2023-12-01T07:34:01.602481Z [error    ] Cannot start plugin target-mssql: Executable 'target-mssql' could not be found. Loader 'target-mssql' may not have been installed yet using `meltano install loader target-mssql`, or the executable name may be incorrect.
2023-12-01T07:34:01.602481Z [error    ] Block run completed.           block_type=ExtractLoadBlocks err=RunnerError("Cannot start plugin target-mssql: Executable 'target-mssql' could not be found. Loader 'target-mssql' may not have been installed yet using `meltano install loader target-mssql`, or the executable name may be incorrect.") exit_codes={} set_number=0 success=False
Need help fixing this problem? Visit <http://melta.no/> for troubleshooting steps, or to
join our friendly Slack community.

Run invocation could not be completed as block failed: Cannot start plugin target-mssql: Executable 'target-mssql' could not be found. Loader 'target-mssql' may not have been installed yet using `meltano install loader target-mssql`, or the executable name may be incorrect.

Hmmm... just as a sanity-check, could you run meltano invoke tap-csv? Really weird that tap-csv is found but not target-mssql. Also, if you could create a brand new meltano project with only those two plugins, try to run it, and share the meltano file with me?

This is a fresh project itself and my first time running meltano.

version: 1
default_environment: dev
project_id: 8343c750-c4d1-4464-8514-9c4e288f7000
environments:
- name: dev
- name: staging
- name: prod
plugins:
  extractors:
  - name: tap-csv
    variant: meltano
    pip_url: git+<https://gitlab.com/meltano/tap-csv.git>
    config:
      files:
      - entity: values
        file: extract/new.csv
        encoding: latin1
  loaders:
  - name: target-mssql
    variant: storebrand
    pip_url: git+<https://github.com/storebrand/target-mssql.git>
    config:
      host: <hostname?
      user: <username>
      dbname: <dbname>

Two questions: If you run

meltano install --clean

, does the output say anything about install failing? Also, what version python do you use?

2023-12-01T10:54:53.953671Z [warning  ] Failed to create symlink to 'meltano.exe': administrator privilege required
Installing 2 plugins...
Installing extractor 'tap-csv'...
Installing loader 'target-mssql'...
Need help fixing this problem? Visit <http://melta.no/> for troubleshooting steps, or to
join our friendly Slack community.

'unicodeescape' codec can't decode bytes in position 645-646: truncated \uXXXX escape

python 3.11.6

Ah, right. Target-mssql doesn’t support Python 3.11 yet. I can fix that in a day or two.

Thanks for your time.

@aniruddha target-mssql is now upgraded and should work with python up to and including 3.11.

Thanks, will check and revert.