• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 398
  • Last Modified:

Changing the Source of an Excel Connection Manager

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
cErasmus
Asked:
cErasmus
  • 2
1 Solution
 
SQL_SERVER_DBACommented:
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
 
SQL_SERVER_DBACommented:
this website has some good examples http://www.sqlis.com/
0
 
cErasmusAuthor Commented:
Thanks, I had to set the delay validation to true.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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