dbTalk Databases Forums  

Data via TCP/IP

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Data via TCP/IP in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Stefan
 
Posts: n/a

Default Data via TCP/IP - 11-20-2006 , 04:35 AM






Hi,
we use SQL Server 2005.
Every 3 seconds we get a string via TCP/IP which data have to be stored in
our database.

Is it possible to read the data directly from the port to the database or do
we have to program a listener which gets the data and pushes them into our
table?

Sorry for my bad English.

Stefan

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Data via TCP/IP - 11-20-2006 , 06:06 AM






Hello stefan,

There is nothing wrong with your English. You will have to write a listener
for this. It could be something you do in a Script Task or it could be a
fully blown Custom Task. I would favour the latter.

How do you intend to "Listen"?

Seems interesting though


Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Quote:
Hi,
we use SQL Server 2005.
Every 3 seconds we get a string via TCP/IP which data have to be
stored in
our database.
Is it possible to read the data directly from the port to the database
or do we have to program a listener which gets the data and pushes
them into our table?

Sorry for my bad English.

Stefan




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.