Wonderful way of explaining the MDX concepts. I have not seen such a clear explanation that too comparing with SQL. Thanks a lot. Request you to please publish all articles...
Connection passwords in a package can stored in package itself. SSIS provides encrypt sensitive information option in the package properties list. Best is encrypt with a password wherein you provide...
If there are 80 records that got inserted out of 100 which are supposed to be inserted into a database, and 81st record got error, then I am re-directing that...