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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. broniusm

    can't get DTS package or step to fail

    MDXer- That did it. I've not got an sql staement to call FTP, and without assigning any return values from that stored procedure call or anything, the output is automatically transferred as an output variable when I asked it to. My ActiveX script checks that string for either "" or...
  2. broniusm

    ActiveX Task Doesn't Follow Workflow

    Rick- Is the problem still occurring, or have you resolved it? Your question sparked my interest, because I was having the same problem. I'd like to share with everyone what I changed to solve the issue, but I don't know! It works exactly as described above, but properly fails the step, not...
  3. broniusm

    can't get DTS package or step to fail

    I've tried fail package on step failure and fail on first. I think I have a lead, though: if I separate the SQL statements within each block with "go" it seems to react to the raiserror. This is a good thing, but now I've got the difficulty of reading my error returned variable...
  4. broniusm

    can't get DTS package or step to fail

    I can't get my DTS to fail, so here's my question to you: Are there tasks in a DTS that can cause a fail to be overridden? For instance: -a DTS package with a single SQL task in it with only the SQL statement: RAISERROR ('FailThis', 16, 1) ..will fail the package nicely: I get a big red X...

Part and Inventory Search

Back
Top