SSIS won't close command when complete

[dpk136]

I am running an SSIS package through a batch file using dtexec.exe. There are 2 other files that need to run after the SSIS. When the SSIS package is done running the command window just stays open and will not close, this makes it so the other 2 scripts cannot run that are in the batch file. Does anyone have any idea why this would not close and allow the rest of the batch file to run. It completes successfully and then just hangs there. This is a very urgent need, please help.

Here is my batch file

@echo off
dtexec.exe /FILE "C:\Documents and Settings\user\My Documents\Visual Studio 2005\Projects\test\test 1.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF
wscript.exe ItemsToFreightReport.vbs
wscript.exe SendEmails.vbs

David Kuhn
------------------

http://www.davidpkuhn.com

 

[dpk136]

I figured it out, not sure why but this is what happened.

We are running a 64 bit system. SQL Server is set in 32 bit due to issues that we had running in 64bit. SSIS was set to run in 64 bit because it detected it was a 64 bit system. I went to the properties of the package and changed Run64BitRuntime to be False. This made the hang up go away.

Does anyone know why this would happen. I got the problem fixed but would like to know why.

David Kuhn
------------------

http://www.davidpkuhn.com