I have searched the SSIS forum for an answer to my question, and I think I have found my answer but what i have read does not come out directly and answer my question.
I am attempting to create an SSIS package that imports data from a Visual Foxpro table into a SQL Server table. From what I have read, the source and destination tables must match column for column. Is this correct My SQL Server table has a few more columns in it. However, i consistently get "Cannot create connector. The destination component does not have any available inputs...blah".
From what i have read, it sound like the reasoning is that my source and destination tables do not match.
Is this correct, or am i barking up the wrong tree
Thanks in advance...
Scott
Source and Destination table equality
Ghost69
I would guess that you are trying to connect a column to the destination but all of the columns are being populated by something else, am I right
When I said that there is no requirement for, in any data-flow, a source and destination to have the same metadata - that is absolutely true.
It sounds as though what you are trying to do is far more specific than "any data-flow" though. You seem to be doing a simple push from one table to another with no transformation in between. Is that true If so, then of course you're going to need a column in the destination for each column in the source - that stands to reason.
Hope that helps.
-Jamie
Misbah M Hasan
OK, then what other reasons why might be getting the above error I am at a loss and, as far as I know, have followed the directions exactly.
jca_john
Scott,
No, there is no requirement for a source table and destination table in a dataflow to have matching metadata.
-Jamie