Here are the list of Industry BI Experts and their Twitter User accounts http://spreadsheets.google.com/ccc?key=ppfitTGNfaCuf1l9u4Au4JQ
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 [...]
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 [...]
