Minimum needs to Deploy SQL Server Integration Services 2008
- by Tim
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