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:
- 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