How to solve error component oledb destination has no input or all of its input are already connected to other output ssis?

Transact-SQL
1

problem

How to solve error component oledb destination has no input or all of its input are already connected to other output ssis ?

I have excel sheet 2007 and have SQL server 2012 with visual studio 2010
I already finish ssis package and when execute package no data Importing from excelsheet to SQL server 2012
although excel sheet have rows
when make double click excel source i can see what inside excel sheet data
when click oledb source destination i can see what inside table on SQL server 2012 data

so what i do to solve this error please ?

What I have tried:

File sharing and storage made simple[^]

CREATE TABLE [dbo].[EMP_A](
	[Id] [int] NULL,
	[Name] [nvarchar](500) NULL,
	[Dept] [varchar](10) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[EMP_A] ADD  DEFAULT ('IT') FOR [Dept]
GO

error issue excel
error issue excel1379×627 27.3 KB

2

please double click on the line connecting them the one with the dots and show us what it does there?

3

thank you for support my problem solved
the problem that i drag old data source and this is wrong
correct drag ole db destination data source