question

ruancra avatar image
ruancra asked

WMI Event Watcher task

Hi all I need to implement error handling in a SSIS package. There's a powershell script in the SSIS package which copies a .mdf file from location A to location B, the copy usually takes about 1 hour. I want to use the WMI task to send a mail when the file has successfully copied over, will the the WMI task report success as soon as it picks up the file name on the destination server, or when the copy is complete? I need it to confirm only when the copy is complete? Thanks Ruan
ssissql2014wmi
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

VishalhSingh avatar image
VishalhSingh answered
SSC has the answers.. check this [Article][1] on SSC. Let's know if this helps. [1]: http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/90571/
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ruancra avatar image
ruancra answered
Thank you Vishalh.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.