in

SQL Server Community Blogs

Voices of the SQL Server Community

exe Raw File Reader

Downloads: 1,307 File Size: 136kB
Posted By: simonsabin Views: 9,930
Date Added: 01-06-2007

A tool for reading raw files produced by SQL Server 2005 Integration Services. This is currently freeware, if you wish to make a contribution via paypal feel free (paypal@onarc.com)

The current feature set is

  • Read any SSIS Raw file
  • Results displayed in a grid
  • Columns automatically resized
  • Order of columns can be changed
  • The results can be ordered by clicking on the column headings
  • You can choose which columns to display (will improve performance for large files)
  • Data can be copied from the results grid using CTRL+C
  • Any set of cells can be copied from the results grid by using the CTRL key
  • Column headers can be included or excluded from the copied data
  • Will remember the last 10 files used
  • Reading of data can be automatic when the columns are read or the data can be read manually once you have selected the columns you want
  • Column selection mechanism is similiar to that in SSIS components
  • Notification when the currently loaded raw file has changed i.e. package is rerun
  • Opton to automatically reload file when file changes
  • Sizeable window to maximise viewing of data in the grid.
  • Column headers can be included if more than one column is selected.
  • Context menu to copy data from the grid
  • Can read a package for raw files and will load each one of them
  • Will remember the last 10 packages read used
  • Option to change the file extensions associated with raw files (thanks Julian)
  • Fixed some spelling mistakes
  • Application is now an MDI application allowing for multiple raw files to be opened at once
  • Rawfile detail windows can be cacaded, tiled as with all MDI windows
  • Enable application for ClickOnce deployment

17th Janurary 2007 1.1.1.0

  • Column headers can be included if more than one column is selected.
  • Context menu to copy data from the grid
  • Can read a package for raw files and will load each one of them
  • Will remember the last 10 packages read used
  • Option to change the file extensions associated with raw files (thanks Julian)
  • Fixed some spelling mistakes
  • Application is now an MDI application allowing for multiple raw files to be opened at once
  • Rawfile detail windows can be cacaded, tiled as with all MDI windows
  • Enable application for ClickOnce deployment
  • First version 1.0.0.0

  • Read any SSIS Raw file
  • Results displayed in a grid
  • Columns automatically resized
  • Order of columns can be changed
  • The results can be ordered by clicking on the column headings
  • You can choose which columns to display (will improve performance for large files)
  • Data can be copied from the results grid using CTRL+C
  • Any set of cells can be copied from the results grid by using the CTRL key
  • Column headers can be included or excluded from the copied data
  • Will remember the last 10 files used
  • Reading of data can be automatic when the columns are read or the data can be read manually once you have selected the columns you want
  • Column selection mechanism is similiar to that in SSIS components
  • Notification when the currently loaded raw file has changed i.e. package is rerun
  • Opton to automatically reload file when file changes
  • Sizeable window to maximise viewing of data in the grid.
  • Comments

     

    Brian Monahan said:

    I tried opening a dtsx file. Is this possible with this tool?
    04-24-2007 5:53 PM
     

    dpsligar said:

    Did this get broken in SP2? When I load a raw file, and try to open it in the RawReader, it shows the fields available, but never opens the raw data file.
    05-09-2007 6:57 PM
     

    sachin.rao said:

    smashing work
    09-05-2007 11:43 AM
     

    apieczyk said:

    Quite useful tool. It's a pity that after register it as "Open with" double click action for the "raw" extension it didn't open the file automatically.
    09-19-2007 8:14 AM
     

    rbenamy said:

    I am having the same problem as dpsligar. I upgraded to VS Team System SP2. I can open raw files and see structure but they do not display in the grid when I the Read File Menu item is clicked. No error msg is received.
    10-19-2007 10:50 PM
     

    andrewknight said:

    I also met the same issue,ManagedDTS's version is 9.0.3042.0
    11-05-2007 5:11 AM
     

    Vension said:

    I too am having the problem as the other guys/girls. I can see the schema, but the data. No error is displayed.
    11-26-2007 3:30 PM
     

    ted@intermz.com said:

    Same trouble, can see schema but no data. Windows XP SP2, .NET 2.0.50727. Any ideas? I'd love to use this tool to debug a mystifying problem I'm having!
    03-13-2008 2:49 PM
     

    Sanjeev said:

    Can see the schema but no data grid. Any ides ?
    06-16-2008 10:54 PM
    Powered by Community Server (Commercial Edition), by Telligent Systems