SSIS Package configuration environment variable was not found while calling it using xp_cmdshell? RRS feed

  • Question

  • I have a SSIS package which loads data from flat file into SQL server Table. For configuration, I'm using package configuration method of using environment variables where we can store the XML file path in variable.

    If the package runs using DTEXEC utility or SQL Job, package detects the env variable and it ran the package fine without any issues.

    If i tried to do execute the package with XP_CMDSHELL procedure, its returning the message saying "package was not able to find "XXXX" environmental variable".

    Even I restarted the SQL Server Agent after i created the environment variable.

    Please share your thoughts.

    Venkat G

    • Edited by Venkat G Thursday, March 17, 2016 9:25 AM
    Wednesday, March 16, 2016 8:10 PM