Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Fouts

  1. Fouts

    Batch Scheduling using SQL

    Thanks All for the suggestions. I will try these things soon. Our server is down now.
  2. Fouts

    Batch Scheduling using SQL

    I was incorrectly calling it before as the input to my ISQL command, however... When I run the command by itself the batch file "spins its wheels" without actually starting the DTS package. The batch window shows the command repeating itself indefinitely.
  3. Fouts

    Batch Scheduling using SQL

    I copied the exact DTSRUN command from the SQL Job step and pasted it into my batch file. It is giving me errors as if it doesn't like the syntax. Is this because of a path problem? I tried running it in the C:\Program Files\Microsoft SQL Server\MSSQL\Binn but got the same results. Here is...
  4. Fouts

    Batch Scheduling using SQL

    Does this correctly keep the dos window open? If so, that is something that would work. Is there any other way to do it using ISQL?
  5. Fouts

    Batch Scheduling using SQL

    How can I keep a batch file active for the duration of a SQL DTS job? The job runs for variable lengths of time but usually around 45 min. to an hour. When I execute this batch job, it immediately returns a 0 for a return code and the DOS window closes. I have other time sensitive jobs...
See more

Part and Inventory Search

Back
Top