Defining precedences between the selected items is not valid

[jambu]

I am trying to create a package by editing a copy of an existing package. The new package is different in that I want a different data source and target but I don't seem to be able to connect the package's new components together using the green and white 'on success' workflow arrows.

The original package had roughly the following layout.

DropTable- - - >CreateTable- - - >Source======>Target- - - >

When I replace the existing source and target and try to connect CreateTable and Source I get the "Defining precedences between the selected items is not valid" error.

This leaves me with a few questions...

1> Can I connect a sql task like CreateTable to a data source using a success workflow arrow?
2> If I can't has anyone any idea how the original dts package was created as it does exactly this?
3>Do I need to connect source and target in this way at all?
4>If I don't need to connect source and target that way, do they just execute seperately from the other code?
5>whether I can connect my source and target this way or not, Can I connect them to on failure activeX scripts like the original DTS package?

Thanks for any help.

 

[gradley]

The source and target should be connected with a "Transform Data Task" (the cog at the top of designer). Unfortunately when you change source and/or destination connections you have to recreate the transformation. As for the other tasks, you should be able to connect all of these with "On success", "on Failure" or "on complete".

 

[jambu]

Just tried that and then connected using the on success arrow, that worked thanks.

Before I was trying to connect the create table to the source first and that was when I got the error.

Thanks for the speedy reply!

 

[gradley]

Glad to help!