ahmed elbarbary

ahmed elbarbary

  • NA
  • 1.6k
  • 281.4k

How to solve error component oledb destination has no input

Feb 16 2020 9:47 AM
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 ?
 
also no data imported to table  
What I have tried:
 
  1. CREATE TABLE [dbo].[EMP_A](  
  2. [Id] [intNULL,  
  3. [Name] [nvarchar](500) NULL,  
  4. [Dept] [varchar](10) NULL  
  5. ON [PRIMARY]  
  6.   
  7. GO  
  8.   
  9. SET ANSI_PADDING OFF  
  10. GO  
  11.   
  12. ALTER TABLE [dbo].[EMP_A] ADD DEFAULT ('IT'FOR [Dept]  
  13. GO  

Answers (2)