SSIS Rawfile viewer - now available
If you've used SSIS in anger you will have come across Raw files.
Unfortunately when you store data in a raw file it is in accesible. There
is no tool available to view the data,
Until now.
I recently put together a tool that allows you to read the contents of the
file, I like to think I've included some neat features, including the automatic
reloading of the file when it changes. This means you can run your package flip
to the raw file reader and the contents of your raw file will be there waiting
for you.
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.
To download the tool go to http://sqlblogcasts.com/files/folders/ssis_tools/default.aspx
This is a version 1 product so I am looking for some feedback on what to do
next, I have some ideas but would like to know what others
want.
-