• satyainfosys - Tuesday, September 25, 2018 9:04 AM

    Hi Jeff,

    Thanks for your prompt response.

    If file is present in Linux server and SQL server is installed in different server , how to load data from Linux File to SQL SERVER ? Do you have document or link ? If yes please share me so that it will be very helpful. I tried to get it in google but no luck couldn't get what am looking.

    Note: Customer is not allowing to place the file where MSSQL Server is running due to security reason. i want to load data from (File present in Linux server) file and load into target SQLSERVER.

    I looking for steps what are the things need to follow.

    One more thing , What is max size packet size in MSSQL ?

    Thanks
    RR

    At some point you are going to have to have the file in someplace that is accessible to the system you are trying to run bcp on and the sql server.  Do you have some kind of a share that is accessible to both the linux server the file is on and the SQL Server?