Post reply

Executive SQL Task

  • January 20, 2006 at 2:17 pm

    #67286

    Hello,

    I am quite new to DTS and I have a problem with an  Executive SQL Task failing when the package is executed - however it runs OK if i execute the step or run it from auery analyzer.

    I think the problem is in the workflow but I can't see anything wrong.

    Your help is appreciated.

    Thanks

    Steve

  • January 23, 2006 at 9:44 am

    #616481

    Hi Steve,

    What error do you get when the task fails?  If you haven't enabled package logging, do so by selecting "Package Properties", the "Logging" tab, then checking "Log package execution to SQL Server".

    Greg

    Greg

  • January 23, 2006 at 12:11 pm

    #616517

    Hi Greg,

    Thanks for the update - I'll turn on the package logging and see where it's falling over.

    Many Thanks

    Steve

  • January 25, 2006 at 8:00 pm

    #617069

    Hi Greg,

    All sorted now!

    Many Thanks for your help

  • January 26, 2006 at 9:00 am

    #617213

    Hi Steve,

    Glad that helped.  Would you share the solution in case someone else has the same problem?

    Thanks,

    Greg

    Greg

Viewing 5 posts - 1 through 5 (of 5 total)

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