Solved

Changing the Source of an Excel Connection Manager

Posted on 2007-11-26
3
394 Views
Last Modified: 2013-11-30
HI Expert, I am trying to create a SSIS package to go through a folder and export all the .xls files into SQL. The problem I'm having is that I'm not to sure which property of the Excel Connection Manager must be changed and how exactly it is done. I know it would be something to do with variables and then in the Excel Connection Manager expressions you change a property during Execution time
0
Comment
Question by:cErasmus
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 16

Expert Comment

by:SQL_SERVER_DBA
ID: 20351084
you have to use a foreachfile enumerator, with the filename being your variable to pass to the Excel Connection Manager. Then it loops importing each file into sql server
0
 
LVL 16

Accepted Solution

by:
SQL_SERVER_DBA earned 500 total points
ID: 20351092
this website has some good examples http://www.sqlis.com/
0
 
LVL 1

Author Closing Comment

by:cErasmus
ID: 31410945
Thanks, I had to set the delay validation to true.
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question