June 8, 2014

SSIS: Cannot Create Connector, The destination component does not have any available inputs for use in creating a path

When creating SSIS package, I was trying to link the data flow source to destination I got the error below.

After looking properly, I realized that instead of using data flow OLE DB destination, I was using data flow OLE DB source in the data flow destination. It was a quick fix, I just had to replace OLE DB Source with OLE DB destination.

No comments: