Sunday, February 19, 2012

connection and getting data from a logfile?

Hi,

i am writing a program that have to get data from a logfile into a database.

Can anyone tell me how to connect and get data from it?

I am working in asp.vb in the Visual Studio 2005 program.

Thanks

There are lots of ways to get data in SQL Server, here are some ideas;

1/ Make sure the file is in a format that Integration Services can read, call it from code.

2/ Use Log Parser

3/ read the data into a datatable/dataset and then use BulkCopy to load that into SQL Server

4/ Lots more

|||

Hi,

thanks for the answer i will shurely try this!

Greetz

Crazydj

No comments:

Post a Comment