I tried to run the SSIS package to load multiple flat files from the NAS drive location. has created the variables, File_Path with data type String and the value as G:\CnS_Pro_Migration_to_QSI-XL\ETL_\Claims\QA\CA_HH_SMART_PRO_MEDCLM_74_CSPFacets_202203C1_202202261309_56662.txt File_Name with data type String and the value as CA_HH_SMART_PRO_MEDCLM_74_CSPFacets_202203C1_202202261309_56662.txt File_Folder with data type String and the value as G:\CnS_Pro_Migration_to_QSI-XL\ETL_\Claims\QA\

I created a for loop container and under Collection where the folder name given as G:\CnS_Pro_Migration_to_QSI-XL\ETL_\Claims\QA\ files: *.txt Under Variables mapping given the variable as User::File_Path.

Under the properties of connection manager for file load and in expressions given as Property as Connection String and Expression as @[User::File_Path]

But on executing the job I got the issue as

[Flat File Source [2]] Warning: The system cannot find the file specified. [Flat File Source [2]] Error: Cannot open the datafile "CA_SMART_PRO_MEDCLM_74_CSPFacets_202203C1_202202261233_56662.txt". [SSIS.Pipeline] Error: Flat File Source failed the pre-execute phase and returned error code 0xC020200E. Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

Could you please help me out?

CodePudding user response：

For an SSIS solution, see the link below.