After looking at this topic I remembered my initial days of MSBI career (~ 8 yrs ago) where I have got a task to handle incremental loads. Such a detailed...

Interesting question. "The ALL will be applied to all values, with the NULL eliminated" may be incorrect. I tried running the same query without COUNT() and found NULL value in...

Sorry for late response. Thanks a lot Mathew and Ed for your reply. Right now we set up email notification when SSIS package fails. When it fails, we jump into...

Thanks alot Ed and Dirt! I appreciate your nod.

Thanks Dirt. There is no MS office istalled on prod Serever. Can I still use the script task? Can you please suggest me a reference for the script task to...

I am downloading xlsb file from web to a databse folder using script task. I have to use that xlsb file to populate one of our table on daily refresh...

I tried same thing to load xlsb file, but when i open in excel source I can't see any data. Can you help me out plz?