December 28, 2011 at 2:58 pm
I have a couple of .xlsx files I am trying to import to sql server 2008R2 db table using SSIS. I set it up such that each file could be extrated from a common folder and dumped into the db table. I used a foreachloop container to iterate the extraction process. The problem I am encountering is that the rowcount that is put in the database table is inconsistent with the rowcount of the source .xlsx files. To be specific I have 3 files with rowcount of 84902, 75262, and 98010. As the rowcount comes out of the SSIS ExcelSource DataFlow task, the number seen is 79087.
I dont enounter this problem if I try to import each file indiviually, that is without using a foreachloop container.
In addition, even without using foreachloop container, I have two other .xlsx files whose rowcounts are 70106 and 79049 and the rowcounts as SSIS ExcelSource DataFlow tasks outputs them is 70,167 and 79087 respectively. And ofcourse all the extra rows have null values.
I am confused as to what is causing this.
In all the cases I have described above the package runs without giving any error or warning message.
December 29, 2011 at 8:31 am
Mr. Campbell thank you for your reply to my post. You are right in your suggestions in that when I hit Ctrl+ end, the cursor goes to the cell that is last imported in both cases and not to the actual end cell. As I have said in my original post, these extra cells are empty and cant understand for the life of me why Ctrl + end would not give the right end cell. I am a novice at this and without sounding like an idot like to ask if CLRF character can be hidden. I do want to add that I edit these files before I load them in SSIS and the now empty rows had data in them at one point.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply