in

SQL Server Blogs

Voices from the UK SQL Server Community

exe Raw File Reader

Downloads: 3,334 File Size: 136kB
Posted By: simonsabin Views: 33,706
Date Added: Sat, Jan 6 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

     

    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.
    Wed, May 9 2007 6:57 PM
     

    sachin.rao said:

    smashing work
    Wed, Sep 5 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.
    Wed, Sep 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.
    Fri, Oct 19 2007 10:50 PM
     

    andrewknight said:

    I also met the same issue,ManagedDTS's version is 9.0.3042.0
    Mon, Nov 5 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.
    Mon, Nov 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!
    Thu, Mar 13 2008 2:49 PM
     

    Sanjeev said:

    Can see the schema but no data grid. Any ides ?
    Mon, Jun 16 2008 10:54 PM
     

    grebnbonnie said:

    Can you point me to a starting point on how you began coding against the object model for the raw file source? We normally use raw files as temporary lookups or cleansed sources. However, when we want to 'clean up' afterwards and remove them after a run due to their size there is sometimes an exception thrown that the file is in use. I am looking for a way to guarantee the failure won't happen. TIA ... not wanting you to give away your work, but I'm having trouble finding the right documentation on MSDN.
    Fri, Jun 19 2009 3:14 PM
     

    ccote_1 said:

    HI, could you possibly tell me how I can use it with SSIS 2008? This utility is very useful and I would like to be able to use it with SSIS 2008 Raw files. Thanks!
    Tue, Apr 27 2010 12:43 AM
     

    NbleSavage said:

    Same comment as ccote1 - having an SS2K8 R2 compatible version would be excellent :)
    Sun, Nov 28 2010 10:49 PM
     

    buddylee17 said:

    Would be great if this worked with 2008 R2.
    Thu, Apr 14 2011 4:47 PM
     

    atomgregg said:

    Hi all.. Same comment here regarding SQL 2008 R2. Cannot open the raw files because of the 'ManagedDTS' library error. Damn useful tool if we could use it. Any chance of opening the source up so we can correct the error..? Cheers.
    Thu, Jun 16 2011 9:18 AM
     

    zahmad said:

    Only showing me the column names(schema). Very strange. Any Ideas?
    Thu, Dec 29 2011 9:32 AM
    Powered by Community Server (Commercial Edition), by Telligent Systems