Capture of Data from input stream -- sql server new users

Tom Moreau
2/18/2005 7:32:19 AM

If the source data is a flat file, you can load it into SQL Server using the
bulk copy program bcp.exe. You can specify your delimiters as well.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
[quoted text, click to view]
Hi all,
I am fairly new at the SQL game, but I have a situation that I wish someone
could help me with.

I have a data feed from a PABX that sends call records out into the real
world. I need to be able to capture that data ("|" delimited and ended with
CRLF) and put it into a table that I can query later.

We currently have a SQL server set up that, if it can do this, I am going to
use.

Is it possible to capture this data or am I going down the wrong path??? If
there is something a bit more efficient to do this, please let me know.

Regards...

rjblanch
2/18/2005 12:29:18 PM

Thanks for the note.

I guess I am having issues with the bit before that then. I need to know
how to capture it into some sort of file.

What I was hoping to do was to send it directly to a Table in the server and
have it update automatically or fill up automatically. The issue I have is
that the PABX pushes data, rather than PC pulling. If it was the other way
around, I would not have a problem of doing this.

Thanks for the note anyway, I guess I will have to keep looking.

[quoted text, click to view]

Tom Moreau
2/18/2005 6:25:10 PM

I'm not really clear on how the data are generated. If your data originates
in the PABX, can it open a connection to SQL Server and insert a row into a
table?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
[quoted text, click to view]
Thanks for the note.

I guess I am having issues with the bit before that then. I need to know
how to capture it into some sort of file.

What I was hoping to do was to send it directly to a Table in the server and
have it update automatically or fill up automatically. The issue I have is
that the PABX pushes data, rather than PC pulling. If it was the other way
around, I would not have a problem of doing this.

Thanks for the note anyway, I guess I will have to keep looking.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

sql server new users : Capture of Data from input stream