error component oledb destination has no input or all of its input are already connected to other output ssis ?
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
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)