Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Component OLE DB source has no input

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 :/

like image 634
user3411180 Avatar asked Mar 12 '14 14:03

user3411180


People also ask

What is OLE DB source?

The OLE DB source extracts data from a variety of OLE DB-compliant relational databases by using a database table, a view, or an SQL command. For example, the OLE DB source can extract data from tables in Microsoft Office Access or SQL Server databases.

What is Ole in SSIS?

The OLE DB Command transformation runs an SQL statement for each row in a data flow. For example, you can run an SQL statement that inserts, updates, or deletes rows in a database table.


1 Answers

you need to connect to an OLE DB Destination not source

like image 128
Jayvee Avatar answered Oct 13 '22 12:10

Jayvee