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...

RTRIM only clears off spaces on the right side of the text. So, you better use LTRIM(RTRIM(ID)) in your source query itself.

Your query is working fine.

select ? = replace((cast(convert(date,min(date_column))as varchar)),'-','') from schema.table

You may need to check some settings in your EXEC SQL Task.

Declare a package variable of string type

Keep...

You can use a EXEC SQL Task, fetch the column value from a table and pass it to a parameter. Attached images might help you.

Here, I am fetching the row...

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...