SQL tables capturing data streams

[rjblanch]

Hi all,

I am just trying to establish if there is a way that I can capture a direct data stream(feed) from another server and have it input into a table.

The scenario is -
I have a PABX that is outputting a stream of data with each record being 83 characters long. Each of the fields is seperated by a space. The end of the record is distinguished by a "Line Feed". The port it is being sent to on my local machine is Port 5000.

Is this possible to do or not? I know that some of our DB guys who use oracle can do it, I would like to have this as a MSSQL database so that I can use it and manipulate it a bit further.

Thanks.

 

[nigelrivett]

Usually you would get the pabx to create files periodically (every minute?) and import them using bcp.


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[rjblanch]

The PABX does not create any files. It just gives out the stream of data. This is a real time feed from calls that are made.

Even if there is a way to capture the string and put into a text file, then I can import that into a table. Does anyone know if this is possible?