SSMS can't open data file

0

Im trying to import a .csv file in SQL Server Management Studio using the import export wizard.

I just created a database and when I used the wizard I ran into several errors. This is the error log.

Pre-execute (Error)
Messages
Information 0x402090dc: Data Flow Task 1: The processing of file "G:\SLIIT\3 YEAR\2 SEM\DWBI\assignment\datasource\steam_description_data.csv" has started.
 (SQL Server Import and Export Wizard)

Information 0x402090dc: Data Flow Task 1: The processing of file "G:\SLIIT\3 YEAR\2 SEM\DWBI\assignment\datasource\steam_description_data.csv" has started.
 (SQL Server Import and Export Wizard)

Warning 0x80070020: Data Flow Task 1: The process cannot access the file because it is being used by another process.
 (SQL Server Import and Export Wizard)

Error 0xc020200e: Data Flow Task 1: Cannot open the datafile "G:\SLIIT\3 YEAR\2 SEM\DWBI\assignment\datasource\steam_description_data.csv".
 (SQL Server Import and Export Wizard)

Error 0xc004701a: Data Flow Task 1: Source - steam_description_data_csv failed the pre-execute phase and returned error code 0xC020200E.
 (SQL Server Import and Export Wizard)

I don't have the file open with any other programs so i'm unsure why it even said it was being used by another program.

any way to fix this?

sql-server
ssms
asked on Stack Overflow Apr 13, 2020 by udara Nadeeshani • edited Apr 13, 2020 by udara Nadeeshani

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0