TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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:
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
Reply
Answers (
2
)
Select previous column value from previous row in Select
date difference