Click here to Skip to main content
15,885,985 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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:

error_issue_excel.png[^]

SQL
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
Posted
Updated 16-Feb-20 4:45am
v3
Comments
PIEBALDconsult 16-Feb-20 10:45am    
That's very strange, I've never seen it before.
But I've never used the Excel source, I always used (past tense) an OleDB source for Excel.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900