Get attendance to the biometric machine directly in SQL through IP

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
MehramAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
RehanYousafConnect With a Mentor Commented:
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
 
Deepak LakkadConnect With a Mentor Commented:
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
 
MehramAuthor Commented:
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
Building an Effective Phishing Protection Program

Join Director of Product Management Todd OBoyle on April 26th as he covers the key elements of a phishing protection program. Whether you’re an old hat at phishing education or considering starting a program -- we'll discuss critical components that should be in any program.

 
RehanYousafCommented:
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
 
MehramAuthor Commented:
in other words I want to say how to generate txt file to import data in database
0
 
MehramAuthor Commented:
sir I haven't idea about SSIS package. please guide me in detail
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.