DTS Task Connections Error

  • I need to create an "On Success" connection between the two circled tasks (see image1.jpg). When I try to, I get the following error (see error.jpg). Other packages have this connection on them, but I can't get it for this one. Any ideas?:D

    Thanks,

    Michael

  • First select the "execute sql task" , then select the input file (using ctrl) and add the workflow.

    The arrows always starts at the task you selected first. If you select the input file first it would point in the wrong direction causing the error message.

    Marc

  • You cannot create a workflow between a task and a connection. Select the task and then select (using ctrl) the data pump task to add the workflow.

    Jez

  • Jez (7/18/2008)


    You cannot create a workflow between a task and a connection. Select the task and then select (using ctrl) the data pump task to add the workflow.

    Jez

    That did it! Thanks you so much!!!!!!

Viewing 4 posts - 1 through 3 (of 3 total)

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