Post reply

WMI COnnection String and SQL JOB

  • May 20, 2008 at 7:16 pm

    #380599

    Hi All,

    I have a requirement to trigger some SSIS packages based on the source files available at the specified location.

    I am using the WMI Event watcher to do the same, its working fine when i run the package from command prompt or from .Net IDE, but the package is going to the infinite loop when i call the package from the SQL Job.

    I am using the script task to set the connection string property which is defined in the config file.

    So can some one help me on how to resolve this issue, as this has to be run as part of regular scheduled daily task.

    Thanks in advance,

    Raju P. S

  • May 21, 2008 at 11:12 am

    #818753

    Can you provide some additional details about exactly what you are trying to accomplish?

    Cheers,

    Ben Sullins
    bensullins.com
    Beer is my primary key...

  • May 21, 2008 at 11:40 am

    #818767

    Hi,

    I have a Scheduled SQL Job which requires few source file to be available to start processing.

    And at times i may not get all the required source files at the same time, so i have to wait / hold the job till i get all the required source files are and then proceed to the next steps.

    I have implemnted WMI Event watcher using the WQL Query to trigger the event when ever the file is available, it's working fine when i run from Command Prompt or from the batch file.

    But when i call the same package from SQL Job its going to infinite loop and not getting the event.

    In my further investigation, i found that the problem is with the SQL Job Credentials and WMI User credentials are conflicting.

    But i am unable to resolve this issue even when i am using windows authentication in both WMI and SQL Server Job.

    Thanks & Regards,

    Raju P. S

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply