I am required to process multiple (32) formatted excel source files (they're actually .xlsm) that have embedded macros, functions, merged cells, etc. These files started out the same, but got processed in many different countries and when they arrive, they look the same. However, some numeric columns import as unicode and some import as float. My problem is, I would prefer to write a package with a foreach loop container to process these files. This works fine for some (the files that match), but I end up with about 12 - 15 files I have to process as separate packages (not within the foreach loop). The rest of the files process fine because all the numeric fields match.
Does anyone know of a way to process these files without writing a separate package for each?
I'm using SQL Server Datatools 2010.
Thank you!
Mark