Hi

I created at SSIS package in BIDS where I use the WMI Event Watcher to
lookout for the creation of a text file, when I run the package from
BIDS it works fine. Now that I'm done, I created a SQL Server Agent
job with the package as a step, but when it "run" the job, it does
nothing - no errors no nothing?

I thought that the problem lay in the different userid NT
Authority\Network service for SSIS and domain\admin for SQL Server
Agent. I changed the userid for the SSIS to domain\admin but no luck.

The funny thing is that any other SSIS job without a WMI Event Watcher
runs fine on the SQL Server Agent job.

Any ideas would be most appreciated

Hello Jens,

But it runs right?

Do you have logging in the package enabled?


Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Allan Mitchell skrev:
Hello Allan

Yes it runs fine, what I due is right click at the job created in SQL
Agent (Start job at step)
I receive a box with following message

Start job 'Test' Success
Execute job 'Test' Executing

About logging, no not yet but I'll in a minute

Hello Jens,

So it just stands and looks at you and says Executing?

You aren't waiting for user interaction anywhere are you?




Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com