SSIS not continuing to next step

  • hex226

    SSC Veteran

    Points: 288

    Hi,

     

    I'm hoping someone can help, I'm new to SSIS and am having difficulty with something I'm sure is quite simple/obvious.

    I've setup a simple project with two steps, both of which are to transfer sql objects from one database to another.  I've linked the steps hoping that when one completes the other will start, however this does not happen when I test the package, and it just stops after the first step.

    Can anyone give me some pointers?

    Many Thanks,

    Kevin

    Attachments:
    You must be logged in to view attached files.
  • Phil Parkin

    SSC Guru

    Points: 243998

    That should work! Assuming the first task completes successfully, that is.

    Can you check the Output window after execution & look for any suspicious messages?

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

  • hex226

    SSC Veteran

    Points: 288

    No, there are no suspicious messages in the output window, which is what I don't understand.

    Attachments:
    You must be logged in to view attached files.
  • Thom A

    SSC Guru

    Points: 98515

    Have a look at the progress pane, rather than the Debug window.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • Phil Parkin

    SSC Guru

    Points: 243998

    How did you execute the package? Did you right-click and select 'Execute Task' by any chance?

    Also, if you double-click on the precedence constraint (the line between the two tasks), a dialog will be displayed. Can you screen shot that dialog & post it?

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

  • Phil Parkin

    SSC Guru

    Points: 243998

    I think that the 'Package Execution Completed' text is usually green (not 100% sure) if everything worked as designed. Blue text means something else (not seen this documented anywhere).

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

  • Thom A

    SSC Guru

    Points: 98515

    Phil Parkin wrote:

    How did you execute the package? Did you right-click and select 'Execute Task' by any chance?

    Also, if you double-click on the precedence constraint (the line between the two tasks), a dialog will be displayed. Can you screen shot that dialog & post it?

    Looks like that's your crystal ball usage for the week, Phil. 🙂

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • Jeffrey Williams 3188

    SSC Guru

    Points: 88260

    I have never utilized this task - so I am not sure, but could this be a case where there isn't any output from the task so nothing to be sent to the next task?

    I know with other tasks that if there isn't any output - the process stops.  For example, a script task that returns a list of files to be processed - if no files found nothing is passed to the next task so it stops at that point.

    Does anyone know what the output from the task would be - and how you would utilize that data for the next task?

    [font="Verdana"]Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster[/url]
    Managing Transaction Logs[/url]
    [/font]

  • Phil Parkin

    SSC Guru

    Points: 243998

    Jeffrey Williams 3188 wrote:

    I have never utilized this task - so I am not sure, but could this be a case where there isn't any output from the task so nothing to be sent to the next task?

    I know with other tasks that if there isn't any output - the process stops.  For example, a script task that returns a list of files to be processed - if no files found nothing is passed to the next task so it stops at that point.

    Does anyone know what the output from the task would be - and how you would utilize that data for the next task?

    The tasks do not have to produce output and can be unrelated – eg, a series of ExecSQL tasks firing off stored procs. Precendence constraints would still enforce execution order.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply