Wow, awesome. Thank you!

Hi there, Brahmanand. The row count is dynamic as it changes. The max size per file should be around 100MB. This will be sent to Azure BLOB and copied to...

Hi there. Yes, it does include a where IsProcessed =! Or should. Seems I forgot to put it back. I’ll use a temp table instead. Thanks for the advice.

Thanks for the advice.  I have data flow tasks. I’ve come to the realization that the only way to do it is to have separate work flows for each table....

Thank you for your response. I end up adding it as a step inside the SSIS package. This is a legacy project that got handed to me. I should've thought...

Thank you for your response! I think I’ll have to get hold of the Snowflake folks it seems.

Thank you for your response. I finally figured out that when I create the staging and working tables one of the variables isn't created the same type across. I changed...

Hey everyone. Thanks for the suggestions. I think I know what to do now. Will let you know once I’ve done it on Monday...