Forum Discussion
PrajwalNarayanaswamy
Dec 20, 2022Copper Contributor
SQL Server 2022 Import and Export
Hello Experts,
I am trying to upload a CSV file to Server 2022 studio to do some querying. But when I try to open the SQL Server Import and Export Wizard, I am getting the following error. I have tried to re install it, but the problem still persists. I have attached some screenshots for the reference. Please do let me know how I can solve this problem.
1234
- G-man777Copper Contributor
This seems to be solved by re-running setup for SQL server and installing Integration Services.
Note: This is NOT available for SQL Express.
(I have been running SQL Express 2022, so it looks like I'll have to install SQL Developer 2022 to gain access to install Integration Services)
- renefkCopper ContributorCan you confirm that the service Account used by Sql Service has the correct rights on the file and the directories leading to it ? (the CSV file), what release of SQL Server are you trying with is it?
Preview?