asked
Foreach loop container import error
Hi, I am trying to append multiple excel source files into one destination ,I used Foreach loop container and here I tried with variable to reed the source files one by one dynamically... My Pkg got run successfully but when I tried with only one source file I got the right out put,when I tried with 2 source files My Pkg got run successfully but I got No of row wrong (lesser then actual count) Please suggest me... Thanks in advance Kandan.M
Did the destination have data from more than just the first file? We need more information than this to have an idea of what you're actually doing?
This tells me that you seem to be looping through the files correctly. Your problem is likely in the logic to insert the records. How are you doing the insert? Using a data flow? If so, are there any transforms in the flow that would filter out records?
Yes, I am using data flow. No transforms were used just one excel source transforms and one ole DB destination
As I noticed no of row where considering (for EX. I have tow files like File Name: A1 consist 10 rows and File Name:A2 consist of 5 rows) while source file mapping I chosen File Name:A2 ...I can see in the destination A2 Files's 5 rows and A1 files 5 rows
16 People are following this question.
