I have created and SSIS package that I am trying to execute in a SQL query. Below is the command I am trying to run:
EXEC master.dbo.sp_configure 'show advanced options', 1
EXEC master.dbo.sp_configure 'xp_cmdshell', 1
execute xp_cmdshell 'DTEXEC.EXE /F "d:\Package1.dtsx"'
Attached I have a screenshot of the error messages I get.
However, when I execute the following from a Windows Command Line, it works fine:
DTEXEC.EXE /F "d:\Package1.dtsx
I have been doing a lot of research and I can’t figure this out. Any help would be greatly appreciated.