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