none
Invoking powershell (SQLPS.exe) scripts using SSIS

    Question

  • 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.

    Thanks,

    Naveen

    Tuesday, September 4, 2012 10:54 AM

Answers