Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Importing Data into SQL DB from IP device

Author  Topic 

hambo12
Starting Member

7 Posts

Posted - 2009-08-30 : 19:47:13
I have been asked to pull some data from an IP connected device on our network. This device is a dumb device that simply buffers the data, and im not sure where it sends it (if it even does).

I need to setup a schedule to import data on a regular basis into an SQL 2005 DB.

The main thing I need to know is how to connect to and pull data from the IP device on our network from SQL server. Is it even possible??

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-08-30 : 20:02:40
SQL Server will need a data source in order to connect to it. I have no idea what data source you'd use though since you don't have any information about the device.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -