Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

bcp export to memory

 
   Database Help (Home) -> Programming RSS
Next:  Full-Text Search  
Author Message
beginthreadex

External


Since: May 30, 2007
Posts: 3



(Msg. 1) Posted: Mon Mar 16, 2009 1:48 pm
Post subject: bcp export to memory
Archived from groups: microsoft>public>sqlserver>programming (more info?)

What facilities are available to get an export from BCP (command line
or API) to memory without hitting any i/o? Importing with the bcp_xxx
api should have an equ for exporting I'm thinking ... no idea where to
look. I'd love to get the export from a BCP into my variables but I
can deal with this a large string of text too.

 >> Stay informed about: bcp export to memory 
Back to top
Login to vote
beginthreadex

External


Since: May 30, 2007
Posts: 3



(Msg. 2) Posted: Mon Mar 16, 2009 2:24 pm
Post subject: Re: bcp export to memory [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Of couse, it seems that facilities for an in-memory file might work
with the bcp_xxx operations ... especially if I can dump the data in a
more RAW format so parsing is very specific and not generic. But, it
would be really awesome to have an API that would allow binding of the
data to either variables or to a string. I would be be happy to have
the bcp api allow me to access some odd char* to the TDS.

On Mon, 16 Mar 2009 13:48:31 -0500, beginthreadex
wrote:

>What facilities are available to get an export from BCP (command line
>or API) to memory without hitting any i/o? Importing with the bcp_xxx
>api should have an equ for exporting I'm thinking ... no idea where to
>look. I'd love to get the export from a BCP into my variables but I
>can deal with this a large string of text too.

 >> Stay informed about: bcp export to memory 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
How to make MODI.Document not leak memory? I have millions.. - How to make MODI.Document not leak memory? I have millions of images to OCR but each time i OCR one it leaks memory. How to do the OCR and then clean up so that my app doesnt leak memory? MODI.Document miDoc = new MODI.Document(); ...

sql2005 Import/Export wizard VS sql2000 Import/Export wiza.. - I created a tab delimited textfile in a vb.net app. I was then able to read the contents of this textfile from the vb.net app and write the contents to a sql2000 DB. I was also able to import the contents of this textfile to the same sql2000 DB usin...

Export - I am working on WinXP Pro & use SQL Server 2005 as the database server. I want to export a few tables existing in SQL Server 2005 to MS-Access 2000 but I don't find any tool to export the tables. In SQL Server 7.0, there was an import/export tool (u...

memory usage - Hello there I have sql server 2000 SP4 I've started placing small tables in the memory by DBCC PINTABLE Can i get on query anlyser the amout of the memory that sql server is using right now? and can i know how mutch of this memory is being using by....

Export to Excel - SQL Server 2005 Enterprise: Server does not have MS Office installed. Is it still possible to export query result to Excel? Regards, Bubbles
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]