ritesh.sinha 54676 - Saturday, June 24, 2017 2:04 AM

Phil Parkin - Thursday, June 22, 2017 7:37 AM

You have missed a step, I think.
Create a new string variable, to hold the file name.
Configure the FEL to map the 'current' file name to the variable you have created.
Use the new variable to define your data source.

Yes, I have a String type variable 'tablenamedest' created and have added this on 'Variable Mappings' screen. And what's happening is that it loads the data in the first table correctly. But after that looks like it keeps on trying to load the same table data again so it fails. The destination SQL table gets the rows that are in one of the files only and the package fails after that. The only file which gets copied is the one which I had given in 'Flat File Connection Manager'-> 'General' -> 'File Name' field. Not sure why is the loop picking this very file repeatedly:
 
Actually there is a table in SQL Server that has a list of flat files' names. I need to load the data of these flat file into another SQL table. Suppose the flat files' names in the first SQL table are table1, table2 and table3. So the data in the flat files with names table1, table2, table3 should get loaded into the destination table say table 'Dest'. 
Error message:
"Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (3) 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.".