RunSqlCmdScripts Feature Request: Log/Output file

[RajAdusumalli]

Hi John,

Thank you so much for creating this very useful extension. Is it possible for you to add an option to add logging capabilities for each file to a specific location?

FYI, I tried using the Invoke-Sqlcmd from powershell with outputas param specified but no output is recorded for the Insert and Update statements (rows affected). Any help would be appreciated.

[DrJohnT]

I will take a look when I get back from holiday

[DrJohnT]

@rajhii
Are you talking about this option for Invoke-Sqlcmd?
Example 2: Invoke commands in a script file and save the output in a text file