Forum Replies Created

Viewing 7 posts - 16 through 22 (of 22 total)

  • RE: DTS Package failing when scheduled

    Oh yeah, and the job history says the same thing the event viewer does. It's not very descriptive, but here it is:

    Event Type: Warning

    Event Source: SQLSERVERAGENT

    Event Category: Job Engine

    Event ID: 208

    Date:  8/22/2007

    Time:  10:08:49 AM

    User:  N/A

    Computer: RTA7

    Description:

    SQL Server...

  • RE: DTS Package failing when scheduled

    I'm using DOMAIN\Administrator to start SQL Server Agent. It's also the same account that I'm using when to login to the machine.

    The schedule is using cmdexec to call the...

  • RE: DTS Package failing when scheduled

    E:\JOBS\Users.txt already exists because the package executed successfully when it was executed by itself. As soon as I schedule the job to run the package, the scheduled job fails. Even...

  • RE: DTS Package failing when scheduled

    There is a physical hard disk (c:\), a dvd/rw drive (d:\) and a second physical hard disk (e:\). These are all local drives.

  • RE: DTS Package failing when scheduled

    I'm running this on the machine where the server resides. The program files for SQL Server are in e:\program files\microsoft sql server\mssql\...

    I've tried using the full UNC path, but still...

  • RE: Resorting a Database View by Alias

    I actually thought about doing this but the only issue is that my Aliases have spaces, so they are getting split up, which washes out any time I may have...

  • RE: Resorting a Database View by Alias

    I had already thought of that... problem being I have a large number of fields (in the vicinity of 250) and that would take a little less time than unchecking and...

Viewing 7 posts - 16 through 22 (of 22 total)