Solved

Get attendance to the biometric machine directly in SQL through IP

Posted on 2013-01-17
6
5,306 Views
Last Modified: 2016-02-11
Dear Experts,
We are using  a attendance machine in our organisation for the employee daily attendance, which have lan facility and working on IP: 10.0.0.186

The vendor have us a patch which get data to the machine and generate text file of attendance. Sample attached. Which I called into SQL through following statement.

delete from Emp_DB.dbo.intermediary
Bulk Insert Emp_DB.dbo.intermediary  From '\\10.0.0.150\Att\txtfile.txt' With (FieldTerminator=',', FirstRow=1, rowterminator ='\n')


Is there any way may I get data directly into MS SQL-2005. Through any store procedure or something else. It would help us to avoid manual edit which generally did by the updating person before update.

Please help
txtfile.txt
0
Comment
Question by:Mehram
  • 3
  • 2
6 Comments
 
LVL 11

Assisted Solution

by:Deepak Lakkad
Deepak Lakkad earned 250 total points
ID: 38786349
You can create procedure and write same code in it.

If file name is changing every time, you can use parameter for file name.

You can execute this procedure from a program or from SSMS.

- Deepak Lakkad
0
 

Author Comment

by:Mehram
ID: 38786874
Sir, This code would work when we load data in database from txt file. but I need to update data into database direct from attendance machine which is on my given IP //10.0.0.186
0
 
LVL 5

Expert Comment

by:RehanYousaf
ID: 38786898
You can create a simple SSIS package which can pick up the file and load it to sql server

SSIS package can be scheduled as a job in SQL Server Agent
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:Mehram
ID: 38786902
in other words I want to say how to generate txt file to import data in database
0
 

Author Comment

by:Mehram
ID: 38786910
sir I haven't idea about SSIS package. please guide me in detail
0
 
LVL 5

Accepted Solution

by:
RehanYousaf earned 250 total points
ID: 38786916
You can try
http://www.codeproject.com/Articles/218914/Steps-to-Create-your-First-SSIS-Package

You will find lot of material if you search on google or bing
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question