DTS Designer Error - Defining precedences...

  • I created a simple DTS package with 2 items: (1) a Microsoft OLE DB Provider for SQL Server connection and (2) an Execute SQL Task in which it executes a stored procedure to INSERT some items into a table.  

    When I try to link these 2 items together with a Workflow 'On Success' green arrow, I get the following error:

    Defining precedences between the selected items is not valid.

    I don't know why I'm getting this error.  I was thinking this was a simple package to design, but can't seem to figure it out.

    Can anyone please assist me?

  • Hi eb24,

    You can link two Task items, not a Connection item with a Task item.

    HTH

    Jeffrey

  • Thanks Jeffrey!  That helped!  I'm not suppose to connect these items! 

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

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