Post reply

Sheduled DTS package fails

  • July 21, 2010 at 11:05 am

    #74303

    I am trying to schedule a DTs Package , keep on failing when we schedule , Executes fine manually from enterprise manager .

    The dts packages takes the data from other machine (Network Drive ), which is mapped . and copy to the local Database

  • July 21, 2010 at 11:06 am

    #1196317

    What is the error message that you get when you run the package as a scheduled job?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • July 21, 2010 at 12:29 pm

    #1196406

    No Error mesage .. Just keep on Exeuting the First Step, never completes

    I look into the profiler ,

    SELECT N'Testing Connection...'

    EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters

    what does it mean ..

  • July 21, 2010 at 12:30 pm

    #1196407

    looks like network Floder mapping Problem ,

    Please Can you tell me How to Start the SQLSERVICES in domain Account

  • July 21, 2010 at 5:04 pm

    #1196557

    Here is a reference article for setting the service accounts to a domain account:

    http://msdn.microsoft.com/en-us/library/ms186264.aspx

    This gives the instructions for the agent, but the same basic steps apply to the SQL Server Service account.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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