Here are the list of Industry BI Experts and their Twitter User accounts http://spreadsheets.google.com/ccc?key=ppfitTGNfaCuf1l9u4Au4JQ
Sep
8
2009
8
2009
Jun
20
2009
20
2009
Adding Expressions in SSIS – Connection Strings
Expressions are powerful in Integration Services. With Expressions you can dynamically set the servername (based on the environment) or the name of the excel file(if it is a fixed format). Let me give you an example. I have a simple Dataflow task(as shown below) that gets the data from a table and exports it in [...]
Apr
6
2009
6
2009
Null value is eliminated by an aggregate or other SET operation
The Problem occurs when an aggregate function(max,sum,avg..) exists on null values. Trying to get rid of the null values may be the solution but in certain cases..you may need the extra data relying on the null values. So whats the solution? Append set ANSI_WARNINGS OFF on the beginning of the sql statement. When using the [...]
