Viewing 12 posts - 16 through 28 (of 28 total)
Hi Experts,
I have installed BCP utility in Linux server.
when am executing below command it throwing error, any input to resolve this issue.
/opt/mssql-tools/bin]$ ./bcp...
October 4, 2018 at 6:16 am
@jeff : Bulk insert is much faster if file exit in Sql server. but our case file is remote location after reading lot of documents then i came to conclusion...
October 3, 2018 at 9:24 am
Ok got it. what is the maximum size file normally process thorough bcp ?
How many parallel process can except bcp by default ?
October 2, 2018 at 9:25 am
Thanks for your response.
I start asking how large is the table you are inserting that much data into?
We have 50 files on daily basis, Each file minimum...
October 2, 2018 at 8:48 am
HI Jeff,
thanks for your response.
Can you please leave your comments on below points.
3. Is there any temp space need to be increase during this process...
October 2, 2018 at 7:22 am
Hi Lynn,
thanks for your prompt response.
I have executed below command but am getting error , can you please help me what could the reason.
Error...
September 25, 2018 at 11:57 am
Hi Lynn,
Before implementation need to understand all areas to complete this task. Beacuse I am beginners in this technology. Sorry to trouble you. I ve to give concrete information...
September 25, 2018 at 11:21 am
Yes, I am not able ping sql server in linux box.
Can you please leave your comments on below queries.
1.give me exact syntax for import command...
September 25, 2018 at 10:37 am
@ZZartin :- if we don't have share path , is there way to do this import through bcp ?
September 25, 2018 at 10:17 am
I already gone through this link but couldn't understand because I am beginner in MSSQL. Can you please give me syntax for import which include error file generation .
September 25, 2018 at 10:15 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...
September 25, 2018 at 9:04 am
Hi Steve,
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...
September 25, 2018 at 8:47 am
Viewing 12 posts - 16 through 28 (of 28 total)