Forum Replies Created

Viewing 15 posts - 16 through 30 (of 34 total)

  • RE: Call DTS from another DTS

    Yes, the message box pops up (sort of) on the server, but if you went to the server and looked, you wouldn't see it. I guess you could...

  • RE: Call DTS from another DTS

    Did you post the correct link? That article doesn't mention MessageBoxes or any GUI elements at all.

    James C Loesch

  • RE: Call DTS from another DTS

    You will never see those message boxes, and the process will wait for a response to them, which will never come. Message boxes only work when you have...

  • RE: Transactional Replication Errors

    No one is updating the subscriber. No one even knows that it exists.

    I have no theories that I haven't already proven false. That's why I posted....

  • RE: Call DTS from another DTS

    Here's an edited sample from one of my scripts:

    
    
    Dim objDTSPackage
    Set objDTSPackage = CreateObject("DTS.Package2")
    objDTSPackage.LoadFromSQLServer "SQLServer", ,...
  • RE: Cancelled DTS continues to run

    Assuming that when you mention the 'Cancel' button, you running the DTS package using the DTS Designer in Enterprise Manager, or you right-clicked on the package in EM and...

  • RE: Transactional Replication Errors

    I am also getting the 20598 error ('The row was not found at the Subscriber when applying the replicated command.'). The problem that I have is that when...

  • RE: DTS works but schedule JOB don't

    The only way that I know to give non-admin users the execute permissions that you want is that check box in the Agent properties, which results in an extended...

  • RE: DTS works but schedule JOB don't

    Karen, the account the SQL Server Agent is running under is the one that will be used for any jobs that run. If that account has admin priviledges,...

  • RE: DTS works but schedule JOB don't

    Disconnected Edit is actually something completely different. Based on the name, I guess it was intended to be used in cases where you wouldn't be connected to a...

  • RE: DTS works but schedule JOB don't

    I guess I better first ask: in SQL 7 DTS Package Designer, is there an option on the Package menu for 'Disconnected Edit'?

    James C Loesch

  • RE: DTS works but schedule JOB don't

    If you have package logging turned on for a DTS Package, then anytime a step in the package executes, there will be an entry added to the log. ...

  • RE: DTS works but schedule JOB don't

    It looks like the package ran, but got an error. To find out what exactly the error is, you'll want to turn on Package Logging. If you...

  • RE: DTS works but schedule JOB don't

    That's not really an error message. Did you check the box at the top of the job history dialog labelled 'Show Step Details'? You will then get...

  • RE: DTS works but schedule JOB don't

    Another question:

    What exactly is the error message?

    You may need to look at the step details in the job history to get the error information. If that...

Viewing 15 posts - 16 through 30 (of 34 total)