I am trying to convert some TXT files in to sqlserver database by using SSIS.
The problem I am facing right now is that some TXT files I have are fixed with line length 286. However, for the some other TXTs they have 296 characters per line. The reason why this happened is some one added one more field before generating those
Instead of creating two SSIS packages for converting those TXTs, can I find another way to get around this?
View Complete Post