Component OLE DB source has no input

database visual-studio-2010 ssis business-intelligence
user3411180 picture user3411180 · Mar 12, 2014 · Viewed 10.2k times · Source

I am new at doing SQL server data tools on VS 2010. However what I try do is:

  1. I have created a textfile and imported it as a flatfile
  2. I try to connect the flat file (with the green arrow) with a OLE DB but get the error:

Component OLE DB source has no inputs, or all of its inputs are already connected to other outputs. You may be able to edit the component to add new inputs to it.

Why do I get this error?

When I open the flat file a have diffrent rows and data in it, so there actually exists data :/

Answer

Jayvee picture Jayvee · Mar 12, 2014

you need to connect to an OLE DB Destination not source

Related questions

Suppress Database Project errors and warnings in visual studio 2010

I have an Database project in my application and want to suppress the errors/warnings thrown by this project. .first of all is it possible ? I think I was not clear with my question, by suppressing I meant that when …

Read More
Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More