In my previous posts << SSIS vs Text File Importing –I >> and << SSIS vs Text File Importing –II >> , we discussed about the Row Delimiter issue of SSIS while dealing with text files and the workaround for the same. In this post I will show you how to achieve the same through SSIS package.
In my previous post named “<<SSIS vs Text File Importing –I>>”, we discussed about the problem statement for the strange behavior of SSIS over importing of Text Files. In this post, I will disclose the reason behind it. Let’s see how Excel and SSIS treats text files while importing data from it.
Last week I come across a serious problem with SSIS while dealing with text files especially with tab delimited text files. It is showing the wrong data after importing into SQL SERVER database. I was shocked by this behavior of SSIS. The total row count in the destination table is much smaller than the source file row count. When I opened the same file in Excel or notepad, I saw the data is correct and properly aligned. Then I deeply dived into the problem and tried to figure out what may be the cause for such an unexpected behavior. Even I am surprised more when I implemented the same process in DTS package (SQL 2000); there it is showing me correct number of records at the destination. Pretty strange, all three products i.e. SSIS, DTS and Excel are from the same manufacturer (Microsoft), but showing different behavior for same type of process (importing data from text file).
Don’t have an account? Create one, its simple
Recent Comments