2
Answers

How to solve error component oledb destination has no input

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)