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