Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2011

    Unanswered: How to query .DAT filedata through SQL server

    I am an automation enginer.. We need to give reports to clients based on the alarm events and data list for the day. Previously we were using some standard softwares given by the company . Now some clients have become economical so they are unable bare those software cost .

    So we planned to give sql reports. all our data is stored in .DAT file which is updated every 3sec.

    Pls tell me how to handke this data

  2. #2
    Join Date
    Aug 2004
    Dallas, Texas
    I'm not too sure I'd attempt this with SQL. I'd probably use VB or some other presentation tool - programming language. But not that it can't be done in SQL. Import (BCP) into a temp table so you can manipulate the data, and use SSRS for the reporting. Other solutions? Import using BI objects (SSIS) and manipulate data. There are several methods to import the data and extract reportings.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts