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
LVL 1
cErasmusAsked:
Who is Participating?
 
SQL_SERVER_DBACommented:
this website has some good examples http://www.sqlis.com/
0
 
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
 
cErasmusAuthor Commented:
Thanks, I had to set the delay validation to true.
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.

All Courses

From novice to tech pro — start learning today.