-
as seen on Server Fault
- Search for 'Server Fault'
I need to run bcp.exe on a client machine which has no SQL Server 2008 installed. Does anyone know the minimum install options I need to select to get the bcp tool? I tried 'Client Tools Connectivity' but that didn't include it.
Thanks, Jon
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I've a master table with identity on for the primary key and I've some child tables. When I insert a record to the master table using BCP, how can I use the newly created ID from the master table to insert in the related child tables (May be BCP again)? Will it be possible? I may be able to set identity…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hey guys,
We have a HPC node that runs some of our tasks in it. I have a task in my .net project that kicks the bcp utility on the HPC node and the output of the query that I have runs into 9 Mb.
When the HPC node runs this task the output of the query is dumped into a file and then after it dumps…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello,
I need to extract and save a some tables from a remote SQL database using bcp. I would like to write a powershell script to invoke bcp for each table and save the data. So far I have this script that creates the necessary args for bcp. However I can not figure out how to pass the args to bcp…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Is it possible for BULK INSERT/bcp to read from a named pipe, fifo-style?
That is, rather than reading from a real text file, can BULK INSERT/bcp be made to read from a named pipe which is on the write end of another process?
For example:
create named pipe
unzip file to named pipe
read from named…
>>> More
