Monday, June 25, 2007

SQL Server: SSIS error: Cannot create connector...

I've been using SQL 2005 SSIS (SQL Server Integration Services) more and more lately. It is a big departure from SQL 2000 DTS (Data Transformation Services), but actually grows on you after a while.

I get the following error pretty often:

Cannot create connector.
The destination component does not have any available inputs for use in creating a path.
If you get this, happy you. This simply means that you have tried to use an OLE DB Source as an OLE DB Destination. The Fix: Simply delete the OLE DB Source and replace it with an OLE DB Destination block, being careful to set all of the connection parameters correctly. Wish they were all this easy.

15 comments:

  1. You are simply genuis

    ReplyDelete
  2. Ha ha! My mother says the same thing. I am happy it worked for you!

    ReplyDelete
  3. Dude! i am not able to find anything that says OleDB destination. all i see is OleDB source. I am not yet able to fix this problem. anyway thanks

    ReplyDelete
  4. Dude! its working now! thanks

    ReplyDelete
  5. Thanks . I am a newbie and was having a tough time figuring this one out

    ReplyDelete
  6. Ditto, I'm also a noob and you probably saved me at least 30 min of hair pulling. So simple, but so glad someone posted this. Thank you.

    ReplyDelete
  7. Yeah, the real problem is that the error message is true, but not very helpful. Maybe it would be useful for the error message to end with, "are you sure you don't need an OLE Destination Block?"

    ReplyDelete
  8. Actually, you also get this error message, when trying to connect a third DB source to a Merge component.

    ReplyDelete
  9. Doh! Thanks for pointing out my stupidity!

    ReplyDelete
  10. Doh! Thanks so much for helping! ;-)

    ReplyDelete
  11. Thanks a lot. I had been battling with this all day!!! Just to realise... THANKS

    ReplyDelete
  12. I've been creating SSIS packages for a while now. I got this error today, read your post, and thought "There's no way I used a source as a destination!" Yup. Thanks.

    ReplyDelete

I moderate comments blog posts over 14 days old. This keeps a lot of spam away. I generally am all right about moderating. Thanks for understanding.