Powershell: Log the results of a SQL query

Question

Stemming from this post: Powershell: Specify file path as variable

I am using Invoke-Sqlcmd in a PowerShell script to execute the following sql query:

update [$Db_name].[dbo].[$BatchTable]
set [$Db_name].[dbo].[$BatchTable].Wave = 'Wave1'
from [$Db_name].[dbo].[$BatchTable]
inner join OPENROWSET(BULK '$FILEPATH',    
FORMATFILE= 'C:\import.xml') AS a
on ([$Db_name].[dbo].[$BatchTable].Name= a.Name) and  
([$Db_name].[dbo].[$BatchTable].Domain = a.Domain)

I am logging a few messages but I am wondering how I can log any errors when the update query is run as well as when a match is found (optimally display a count successful and unsuccessful matches)

Are you looking to log SQL errors or PowerShell errors?

TheMadTechnician
– TheMadTechnician

2015-04-30 00:42:54 +00:00
Commented Apr 30, 2015 at 0:42 — TheMadTechnician
– TheMadTechnician, Commented Apr 30, 2015 at 0:42
I am looking to log SQL error

Anthony Ryan
– Anthony Ryan

2015-04-30 01:31:54 +00:00
Commented Apr 30, 2015 at 1:31 — Anthony Ryan
– Anthony Ryan, Commented Apr 30, 2015 at 1:31

Community · Accepted Answer · 2017-05-23 12:02:59Z

1

The MSDN documentation mentions that you could use the -OutputSqlErrors command line parameter with Invoke-Sqlcmd to display errors encountered while executing the SQL command.

EDIT: This SO post might also be helpful to you

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered Apr 30, 2015 at 1:10

jithinpt

1,2642 gold badges19 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Powershell: Log the results of a SQL query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related