SSIS Tips: Extract and Populate Multiple Table Relational Data from Multipart File

I’m back with another scenario regarding text file data transfer.The impetus to writing this blog was recent mail I got from one of my blog followers. He had a scenario which he wanted me to provide him with a solution…

SSIS Tips: Handling Inconsistent Text Qualifiers in Flat File Source

Last week I had blogged about how to handle embedded text qualifiers coming in flat file source data in the below blog.http://visakhm.blogspot.in/2014/06/ssis-tips-handling-embedded-text.htmlOne of the feedback I got was from a ETL developer who asked whether its possible to handle files…