Hi All,
I'm pretty new using SSIS and I'm trying to simplify something that I'm building. I have software
that downloads multiple excel files and save them on a share drive. I
need to build a package that can import the different files into
different tables in sql without having to create a single package per
file. There are around 20 files but the tricky part is that those files
are downloaded every hour. I need a way if possible to create a single
package to import those files and then archive them to another
directory. Also the files have the initial file name description and
then it add random numbers at the end. If anybody have done this before
or can give me some light i'll really appreciated.