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.
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.