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…

T-SQL Tips: Retrieve Connectionstring Details from SSIS Package

I’ve published a new article on MSDN Wiki which explains how connectionstring details can be extracted from an existing SSIS package.You can find the article in the below link http://social.technet.microsoft.com/wiki/contents/articles/25150.t-sql-retrieve-connectionstring-details-from-a-ssis-package.aspx This approach can be used when you want to audit…