Using a UNC Path in WMI Event Watcher Task


i'm configuring wmi event watcher task serve file watcher on unc share.  task configured follows:

wmi connection:

server name: \\devdb01

namespace: \root\edi_files

windows authentication

wmi event watcher task

wqlquerysourcetype: direct input

wqlquerysource: select * __instancecreationevent within 10  targetinstance isa "cim_directorycontainsfile" , targetinstance.groupcomponent = "win32_directory.name=\"\\?\unc\devdb01\\edi_files\""

the task fails following error message: [wmi event watcher task] error: watching wql query caused following system exception: "invalid namespace". check query errors or wmi connection access rights/permissions.

how configure task use unc share on server?


you have map first: net use d: \\unc\devdb01\edi_files\ unc not work (afaik).

please mark post answered if answers question | ssis blog: http://microsoft-ssis.blogspot.com | twitter



SQL Server  >  SQL Server Integration Services



Comments

Post a Comment

Popular posts from this blog

SQL Server PSProvider SQL Server Authentication

greetings: i'm trying use sql psprovider powershell.  can make work management studio by right-clicking next database object.  however, unnable external powershell session. note: i have tried using suggested method msdn ( initializesqlprovider.ps1 , function sqldrive ) i following error: new-psdrive : sql server powershell provider error: not connect 'emtyb06\default+bca_empresarial'. [object ref erence not set instance of object.] @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -credential $cred -scope 1 new-psdrive : sql server powershell provider error: path sqlserver:\sql\emtyb06\default+bca_empresarial not exist.  please specify valid path. @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -cred...
Read more

Reindexing

hi     using sql server 2005 ee sp4. our database size 150 gb. weekly once schedule reindex job. ran 4 5 hours maximum. but recent days getting more 13 hours. the possibilities there? ragu thangavel how perform reindex? maint plan? or check fragmentation first , reorganize fragmented? if later, quite more data nowadays fragmented before. if not, consider doing "smart" defrag (ola.hallengren.com). tibor karaszi, sql server mvp | web | blog SQL Server  >  SQL Server Database Engine
Read more

How to calculate the delta size while diffing the files in TeamFoundationServer ?

currently, need calculate delta size while diffing files in teamfoundationserver, don't know wheter there are existed tfs api in msdn. far did not find it. familiar it? or deliver suggestions? thanks in advance !! thanks materials !! here solution below: private int calsinglefiledelta(string strbase, string strshelve) { int nfiledelta = 0; arraylist alorgstart = new arraylist(); arraylist aldesstart = new arraylist(); arraylist alunchangedlen = new arraylist(); diffsegment diffseg = difference.difffiles(strbase, encoding.ascii.codepage, strshelve, encoding.ascii.codepage, new diffoptions()); if (diffseg != null) { alorgstart.add(diffseg.originalstart); aldesstart.add(diffseg.modifiedstart); alunchangedlen.add(diffseg.modifiedlength); while (diffseg.next != null) { diffseg = diffseg.next; alorgstart.add(diffseg.originalstart); ...
Read more