• Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 40
  • Last Modified:

Error in SSIS

I am not understanding this error. Can any one please help me out?

screenshot.pngscreenshot2.png
0
mustish1
Asked:
mustish1
2 Solutions
 
SimonCommented:
What are you attempting to do: import from Excel or export to Excel? I ask because you have the Excel source highlighted in the toolbox on the left, while on your data flow it looks like you might intend to export to it.
0
 
Rainer JeschorCommented:
Hi,
SimonAdept is right. You have used an Excel Source, but you should have used an Excel Destination
(the arrow directs from the Excel to the right).
Just remove the Excel component and select the related destination component and connect the source with the new destination.

HTH
Rainer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now