Invoking powershell (SQLPS.exe) scripts using SSIS


  • Hi,

    I have written powershell scripts which access remote SQL Server tables and exports it into Excel. It has been tested using SQLPS. I used to call this scripts using a batch file.

    If I execute the batch file, I am able to get the expected results, but if I am truing to call this batch file using SSIS, I am not getting the results. SSIS excutes without any errors, but excel export which is written through SQLPS is not happening.

    Any help is appriciated.



    Tuesday, September 4, 2012 10:54 AM