|
|
-
|
|
Many times we want to associate a tablix with more than one dataset in reports but we are not able to do so in SSRS 2008 and previous versions. This limitation has been taken care of by some RDL expression language enhancements in SSRS 2008 R2. Lookup, LookupSet and MultiLookup are some really cool ......
|
|
-
|
|
I have written a paper on SSIS package configurations based upon my experience and learning in projects. After a lot of reviews, finally it has been published and can be found at: http://www.infosys.com/microsoft/resource-center/Documents/SSIS-package-configurations.pdf ......
|
|
-
|
|
I gave a presentation on power pivot and its new features today. I discussed about various capabilities of power pivot including DAX and Slicers. I showed demo on "creating a power pivot model" and "enabling data refresh inside Share Point". It all went well, people were asking questions about thes......
|
|
-
|
|
Let's see how to add an assembly inside SSIS script task. At first, create a simpe class library without any code and build it. I have copied my dll from the default location to D:\SampleTest\CustomAssembly. Then add a script task to a new ssis package and open the script task's editor and try to ad......
|
|
|
|
-
|
|
I have seen a lot of queries on forums to create an excel file of a particular format and then use it inside a data flow task. File System Task does come to the mind but unfortunately there is no "Create" operation inside File System Task. But there is a workaround with little bit of......
|
|