Hi,

I would like to run SSIS 2008 packages on a server that does not have SQL Server 2008 installed on it. I have a simple package to test the concept, but it fails to execute. The return code is 9020 which I have not seen listed as a return code elsewhere.

I have copied the following files to the test server that does not have SQL Server 2008 installed on it:

SelfContainedSample.dtsConfig Package.dtsx DTExec.exe

I am attempting to run the package using a batch file. The line in the batch file that runs the package is:

"%dtexecloc%\dtexec.exe" /FILE "%packagefolder%\Package.dtsx" /CONFIGFILE "%configfolder\SelfContainedSample.dtsConfig" /CHECKPOINTING OFF /REPORTING E >>%logfile% set rc=%errorlevel%

I am wondering if there are other requirements that need to be satified to run an SSIS 2008 package on a server that does not have SQL Server 2008 on it? .NET Runtime? SSIS 2008 runtime?

Please share your advice if you have a solution or have met this issue before.

Thanks, Tim