'SSIS: Start data load package for final table
I have a daily 5 txt file in a Arrived folder, I'd like to design a SSIS package: each the txt file data load to stage then file goes to archive folder, if file not processing and load to stage then it will not goes archive, if all files load or not in stage this package job done. I have other package for stage to final table load but I want to make sure all files are load in stage then only this package run otherwise not run. how I will design SSIS package?
Can somebody help me?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|