Error: To run a SSIS package outside of SQL Server Data Tools you must install GetDate of Integration Services or higher

Question

Hello, I have a peculiar error when running a SSIS package using a batch file. I believe it is erroring due to the run duration of the package. When I execute the below code, the package will run for a little, successfully run a few tasks, and then produce the Error "Description: To run a SSIS package outside of SQL Server Data Tools you must install GetDate of Integration Services or higher." Here is the .bat script:

@ECHO OFF



CLS

set LOGFILE="logfile.txt"
call :LOG > %LOGFILE%
exit /B
:LOG

ECHO My Test Package executing from batch file



"C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\DTExec.exe" /File "C:\ElliotSSIS\Elliot_VS2019\SSIS_VS_2019\ARS_Incident.dtsx"

The strange thing is that I can run other packages with success. For example, the below code works fine (though the SSIS package is much less complex, and therefore runs faster):

@ECHO OFF



CLS

set LOGFILE="logfile.txt"
call :LOG > %LOGFILE%
exit /B
:LOG

ECHO My Test Package executing from batch file



"C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\DTExec.exe" /File "C:\ElliotSSIS\Elliot_VS2019\SSIS_VS_2019\ARS_File_Load.dtsx"

Has anyone experienced this anomaly?

Answer 1

Hi @Elliotvs22,

To run a SSIS package outside of SQL Server Data Tools you must install GetDate of Integration Services or higher.

It seems that one of your package is using GetDate which is a name of the component and the other does not use it.

On this machine, although SQL server is installed, the shared components required for Integration Services are not. In this situation it is still possible to run very simple SSIS packages, because ‘dtsexec.exe’ is installed.

Rerunning the installation confirms the absence of Integration Services components:

https://learn.microsoft.com/en-us/sql/integration-services/install-windows/install-integration-services?view=sql-server-ver16

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.