This project has moved. For the latest updates, please go here.

Previous Install SSIS Dimension Merge SCD Manual Install Install SQL 2005 Backward Compatibility Next

Install SSIS Raw File Reader

FineBuild can install and configure the SSIS Raw File Reader as part of the SQL Server install process.
If you do not want to include SSIS Raw File Reader in your FineBuild install, then do not download it.

SSIS Raw File Reader is written by Simon Sabin, a SQL Server MVP. Data being processed by SSIS is passed between components using what are known as SSIS Raw Files. The SSIS product does not provide any functionality to examine the contents of Raw Files, which can be a problem during troubleshooting. The SSIS Raw File Reader was chosen to be included in FineBuild because it provides this missing functionality.

SSIS Raw File Reader home page http://sqlblogcasts.com/files/folders/ssis_tools/entry1528.aspx
SSIS Raw File Reader download http://sqlblogcasts.com/files/folders/ssis_tools/entry1528.aspx
SSIS Raw File Reader tutorial http://www.simple-talk.com/sql/ssis/how-to-read-raw-files-in-ssis/

SSIS Raw File Reader is not required for SQL Server 2012 or above.

FineBuild SSIS Raw File Reader Install

Automated silent installation of SSIS Raw File Reader is performed by Process Id 4ID and is controlled by the parameters below:
Install Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupRawReader FULL Yes Yes Yes N/A N/A
SetupSQLTools No No No No No
SetupRawReader WORKSTATION Yes Yes Yes N/A N/A
SetupSQLTools Yes Yes Yes Yes Yes
SetupRawReader CLIENT Yes Yes Yes N/A N/A
SetupSQLTools Yes Yes Yes Yes Yes

In order to maintain compatibility with older versions of SQL FineBuild, the parameters InstRawReader and InstSQLTools can also be used.

FineBuild also uses the following parameters to help install SSIS Raw File Reader:
Parameter Default Value Description
RawReaderexe RawFileReader.exe Name of SSIS Raw File Reader program file

SSIS Raw File Reader will be installed with CLIENT and WORKSTATION builds, but not with a FULL build.
If you want to install it with a FULL build, the following parameter should be added at run time:
/SetupSQLTools:Yes
The FineBuild install for SSIS Raw File Reader includes the following:
  • Perform a SSIS Raw File Reader install
  • Add a menu item for SSIS Raw File Reader to the Integration Services menu.

Manual SSIS Raw File Reader Install

The following steps show what you would have to do to install SSIS Raw File Reader manually. FineBuild does all of this work for you automatically.

Install SSIS Raw File Reader

1) Navigate to the Additional Components folder. Right-click on RawFileReader.exe and select Copy.
RawReader Explorer.png
2) Copy RawFileReader.exe to:
For a 32-bit installation: C:\Program Files\Microsoft Visual Studio 8\Common7\Tools
For a 64-bit installation: C:\Program Files (x86)\Microsoft Visual Studio 8\Common7\Tools.

Setup Menu Item

1) Highlight the RawFileReader.exe file, then right-click and select Copy.

2) Navigate to the SQL Server Integration Services menu folder on C: and select Paste Shortcut.

3) Rename the menu shortcut to Raw File reader.

Copyright © 2011 - 2014 Edward Vassie. License and Acknowledgements
Previous Install SSIS Dimension Merge SCD Top Install SQL 2005 Backward Compatibility Next

Last edited Oct 31, 2014 at 5:14 PM by EdVassie, version 18