I basically use this for my packages. Something to consider is still use package configurations to denote the various environments...assuming you have a SQL Server running SSIS in DEV, QA,...

Your MongoDB components look very interesting and if I ever need to pull from Mongo again, I will test them and see how they do. Hopefully, I won’t see Mongo...

Clover does give you a trial time to use their tool. There is a learning curve with manually setting up the metadata and mappings but they may have resolved some...

I spent a lot of time researching this and tested a handle full of third-party ETL packages. Mongosis would have been a great choice but at the time of testing...

Talking with our HR and recruiting team, I’ve learned experience and personality trumps certifications or degree. However, a wide combination of experience, certifications, and/or college degree is a filter used...

I suggest having your Oracle DBA set up a user and password specifically for your SSIS package…I’m assuming READ only will put your security folks at ease. After you install...

You can grab a percentage this way...

select (select cast(COUNT(ColumnB) as decimal) / (SELECT COUNT(*) FROM Table)

FROM from table) * 100 as PercentofTotal

I haven't played with SSRS but in SSIS there is a Send Mail option but I found it a little too structured for some of my projects.

Something I might explore...

My first thought is how is the content arriving in the html file? Is it static or dynamic content?

That got me on the right path.

Thanks and I owe you a warm up on coffee 🙂