This blog speaks about some of the critical things you need to be aware of while implementing a delete logic for your project.The impetus for writing the blog is a recent experience we had due to a small oversight in…
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…
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.…
String Comparison in SSIS Lookup Task SSIS vs T-SQL Engine
Recently a colleague of mine came to me with an issue he was facing. He was trying to do mapping of data from a flat file source against a reference table to get the conversion codes corresponding to the incoming…
SSIS Tips: Conditional Processing of Files Based on FileTypes
One of the common requirements that we come across in any data warehousing project is the ability to process different types of files to extract data from them onto our data warehouse. For this purpose SSIS provides a ForEach loop…
SSRS Tips: Displaying Copyright and Trademark Symbols in Report
Recently for one of my friend asked me whether we could display copyright (©) and trademark (™) symbols inside SSRS report textbox. He was dealing in a retail project and wanted to show copyright and trademark symbols along with description…
SQL Agent Tips: Configure Custom Schedule for SQL Agent Job
There have been few instances of late where I’ve seen requests in the forums asking for scheduling jobs using a custom schedule in SQL Server agent. I had given the solution for them in the forums. Thought of sharing it…