Yearly Archives: 2012

Look-up Task fails in SSIS2005

Khilitchandra's Business Intelligence Blog Posted on by

You already know that SSIS 2005 has more issues than SSIS 2008 version. I have also came across an issue regarding Look-up Task. When you use Look-up Task in your dataflow activity. Sometime it runs and sometimes it fails. Well, there could be many reasons, but we will discuss about one of the reason that is related to the “caching”. Look-up uses caching for fast comparision of values. So, you might have faced something like this. You have configured look-up correctly and when you run, you will see following 🙁

Continue reading →

How Do I Configure My SSIS Package?

Khilitchandra's Business Intelligence Blog Posted on by

Well, the correct answer to this question is – “That Depends“. There are lots of things requires your attention when you start making your package configurable. For better illustration, lets take e.g. of one simple scenario. I have a package named “TransferDataPackage.dtsx“. This has only one data flow task in which, i have a OLEBD Source and OLEDB Destination tasks. In short, i am transfering data from “SourceServer” to “DestinationServer”. (Names in double quotes are exact names of entities used in example) And now i want to make this package configurable. Demo project is shown below:

Continue reading →

Select records from one table which are not available in another table

Khilitchandra's Business Intelligence Blog Posted on by

Hi guys. I have seen people having hard time when they try to achieve similar functionality which is provided by “Except” keyword in T-SQL. I am talking about the case when people need to select those records from one table which are not available in another table. Well, if both these tables are in one database, you can definately use SQL query and make use of Except keywork. But if tables are in different database then… And then people start experimenting with Merge Join Task and later start googling it. One of the mandatory condition while using the Merge Join … Continue reading →