Forum Discussion

PrajwalNarayanaswamy's avatar
PrajwalNarayanaswamy
Copper Contributor
Dec 20, 2022

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

Integration Services

2 Replies

  • G-man777's avatar
    G-man777
    Copper Contributor
    Jan 19, 2023

    PrajwalNarayanaswamy 

     

    This seems to be solved by re-running setup for SQL server and installing Integration Services.

     

    Note:  This is NOT available for SQL Express.

     

    https://learn.microsoft.com/en-us/sql/integration-services/install-windows/install-integration-services?view=sql-server-ver16

     

    (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)

     

     

  • renefk's avatar
    renefk
    Copper Contributor
    Dec 21, 2022
    Can 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?

Resources