SSIS .dtsx package that can loop through a folder and find File_Name*.csv. It should then upload the csv data into an stg.Table_Name. Next it will Truncate dbo.File_Name. Then it will import data from stg.Table_Name to dbo.Table_Name. If the import fails I do not want the dbo table to be Truncated. I only want dbo.Table_Name to be truncated if the stg.Table_Name upload is successful.
Folder Structure pieces of information,
Do not change the folder structure because I have created this structure inside the package.
C:\FileUpload_ETL_SSIS
C:\FileUpload_ETL_SSIS\Processing
C:\FileUpload_ETL_SSIS\Processing\ArchiveFiles
C:\FileUpload_ETL_SSIS\Processing\EmptyFiles_For_Processing
Unzip- "Required_EmptyFiles_Templates.zip" folder file templates there are total of 9 files
https://github.com/eshohag/FileUpload_ETL_SSIS/tree/master/Dcouments
https://github.com/eshohag/FileUpload_ETL_SSIS/tree/master/Dcouments/Scripts