question

kandanDevi avatar image
kandanDevi 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
ssissql-server-2012ssms
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Alvin Ramard avatar image
Alvin Ramard answered
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?
4 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

yes its having more then then the first file
0 Likes 0 ·
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?
1 Like 1 ·
Yes, I am using data flow. No transforms were used just one excel source transforms and one ole DB destination
0 Likes 0 ·
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
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.