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.

Posted by Timothy Chen Allen at 4:18 PM

Labels: ,

15 comments:

  1. AnonymousApril 29, 2008 at 4:48 AM

    You are simply genuis

    ReplyDelete
  2. Timothy Chen AllenApril 29, 2008 at 6:29 AM

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

    ReplyDelete
  3. VikiAugust 6, 2008 at 8:13 AM

    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. VikiAugust 6, 2008 at 8:46 AM

    Dude! its working now! thanks

    ReplyDelete
  5. AnonymousOctober 13, 2008 at 6:40 PM

    My face is red!

    ReplyDelete
  6. AnonymousMarch 23, 2009 at 3:20 PM

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

    ReplyDelete
  7. Timothy Chen AllenMarch 23, 2009 at 3:25 PM

    Great! Glad it worked for you.

    ReplyDelete
  8. AnonymousMay 5, 2009 at 10:14 AM

    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
  9. Timothy Chen AllenMay 5, 2009 at 10:21 AM

    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
  10. PJanuary 29, 2010 at 4:51 PM

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

    ReplyDelete
  11. UnknownMarch 9, 2010 at 10:13 AM

    Doh! Thanks for pointing out my stupidity!

    ReplyDelete
  12. ElizabethJune 23, 2010 at 5:39 PM

    Doh! Thanks so much for helping! ;-)

    ReplyDelete
  13. debbieFebruary 15, 2012 at 9:53 AM

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

    ReplyDelete
  14. Chris AMarch 8, 2012 at 9:45 AM

    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
  15. Jophy SamuelOctober 23, 2013 at 10:44 AM

    Lol.....Thanks a lot..Its working

    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.

Subscribe to: Post Comments (Atom)