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…
SSIS Tips: Handling Embedded Text Qualifiers in SSIS Flat File Source
Recently in one of my projects there was a case where I had to transfer the data from flat file to SQLServer table. The file was generated by an automated process at the client side and was FTPed to our…
SSIS Tips: Implementing SCD Functionality Using Hashing Method
There are numerous ways in which you can implement slowly changing dimension processing in SSIS. There is also a standard task available in SSIS called SCD Task for this. But the task will cause a performance bottleneck for large tables.…