shaikwaseem888 - Saturday, December 30, 2017 3:24 PM
Unless the server is on your desktop (or lap top) where the "‪C:\Users\Shaik\Desktop\Import.csv" file lives, the server won't be able to see the file. Even if it does live on the same box as the file, it may still not be able to see the file because it's (apparently) in your user directory and the server may not have privs to access that folder. Even if the server can see the file, it won't be able to open it if another application (other than NotePad) has it open (for example, you have the file open in Excel).
You can solve this issue by granting the SQL Server logins privs the machine/drive/folder where the file lives and we can help with that, but we first need to know where all the pieces live..
Since it IS BULK INSERT, we may have to do a little song and dance to get things to work depending on what your privs on the server are.
--Jeff Moden
Change is inevitable... Change for the better is not.