timovski / csvpaste Goto Github PK

When I was reading the Installation Guide, I could initially not figure out where the path was supposed to exist. When looking at my installation directory, there was no subfolder for Management Studio inside my SQL Server installation folder. Then going up several directories, I found the path of my Microsoft SQL Server Management Studio 18 installation and the Extensions folder:

C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Extensions\

However, this prompts an error on every Paste as CSV attempt that it is missing a Component/DLL. I presume this addon was made with Version 140 in mind and may not work with newer versions, let alone the stand-alone installation of Management Studio?

Is there a fix for this, or would it require a rebuild linking to the missing Component/DLL? Does the extension presume that you have an older version of Visual Studio SDK installed?

Thank you, very good contribution, I am using ssms 18 and when I press "Copy as CVS" it tells me
Unable cast object of type
'Microsoft.VisualStudio.ComponentModelHost.ComponentModel' to type 'Microsoft.VisualStudio.ComponentModelHost.ComponentModel'

I've followed the installation instructions, and have tried putting all three files in both C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Extensions and, in case I'd misinterpreted the instructions and I was supposed to include the parent folder, C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Extensions\CSVPaste.

I initially put them directly in the Extensions folder. I did receive the warning message. I selected No, closed SSMS, and restarted SSMS. I ran a select statement, copied cells from one column in the results grid, then attempted to paste into the query pane.

Expected: "Paste as CSV" appears below the Paste option.
Actual: No Paste as CSV option appears.

I then tried quitting SSMS, deleting the files, then copying over the files within the CSVPaste folder.

I am using SSMS 18.6 and did confirm that's the version being opened.