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.



-
Published Thursday, January 11, 2007 11:58 AM by simonsabin

Comments

Sunday, January 14, 2007 3:46 PM by Julian Kuiters - Simon Sabin's SSIS Raw File Reader

# Julian Kuiters - Simon Sabin's SSIS Raw File Reader

Sunday, February 4, 2007 2:20 PM by .NET Tools Blog

# Integration Services Raw File Viewer

Friday, December 19, 2008 1:46 PM by Vladimir

# re: SSIS Rawfile viewer - now available

Hello Simon,

It's a nice tool! I'd suggest to support file names passed in command line arguments. In this case RawFileViewer could be made the default viewer for RAW file in explorer.

Sunday, May 10, 2009 8:55 PM by SSIS Junkie

# SSIS Connect Digest 2009-05-10

I have noticed a few fellow SQL bloggers over on SQLBlog.com (most notably Aaron Bertrand ) have started

# SSIS Connect Digest 2009-05-10 | WORDPRESS-TEMPLATES-PLUGINS-RSS | SSIS Connect Digest 2009-05-10 >>>

Pingback from  SSIS Connect Digest 2009-05-10 | WORDPRESS-TEMPLATES-PLUGINS-RSS |   SSIS Connect Digest 2009-05-10 >>>

# SSIS Connect Digest 2009-05-10 | WORDPRESS-TEMPLATES-PLUGINS-RSS | SSIS Connect Digest 2009-05-10 >>>

Pingback from  SSIS Connect Digest 2009-05-10 | WORDPRESS-TEMPLATES-PLUGINS-RSS |   SSIS Connect Digest 2009-05-10 >>>

Sunday, June 21, 2009 2:15 PM by Charley Hanania

# SSIS Rawfile viewer

One of my colleagues griped about SSIS Raw files recently, so I thought I'd quickly post the link

Monday, November 30, 2009 8:11 AM by AmosChong.com

# SSIS Raw File Reader

SSIS Raw File Reader

Friday, February 19, 2010 4:53 PM by handyman999

# re: SSIS Rawfile viewer - now available

i suggest you get it to work before posting.

Thursday, February 7, 2013 10:48 PM by SQL Server

# SSIS Raw File Viewer (2008/2008R2)

Back in 2007, Simon Sabin published a file viewer for SSIS RAW files . Of course, that was for Integration