Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004

    Unanswered: Please help - Is this even possible??

    I am executing multiple stored procedures in a stored procedure, pulling back a table of results, which is activated by a crystal report. One of the stored procedures activates a DTS Package. My problem is that the activation of the dts package returns output results, which in turn throws off my crystal report. Is there a way to still run this stored procedure as is but without returning the DTS output results??

    I am using Sql 2000 and Crystal 8.5.

    I would really appreciate any suggestions.


  2. #2
    Join Date
    Apr 2004
    Kansas City, MO
    You can create the temp table and insert the execution of the dts package into the temp table. This will "capture" the results and effectively mask them from being seen as output. You will also probably want to use SET NOCOUNT ON in your procedure.
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts