Here's what I see when I click on 'New'? Can anyone confirm, do I really need to install a Hadoop server to pull data out of this AVRO file? Having...

Thanks for your fast response Phil! HDFS File Source task is asking for a Hadoop Connection Manager. All I have is the AVRO file... so not sure what to do...

Thanks Mike, it is 2016, however I've learned since my initial post that the database was migrated from 2008 and therefore has kept it's Compatibility Level 100 which does not...

Thanks again Mike, apparently my enterprise has not updated to a version that supports OPENJSON. I am able to use JSON_VALUE however. Any bright ideas? I really appreciate your time!

Thanks Mike for your response, I'll dig into this next week and see what I can make happen.

Thanks guys. I actually found these two link together pretty helpful:

databasejournal.com

SQL Server 2012 Integration Services - Package Deployment

http://www.databasejournal.com/features/mssql/ssis-2012-integration-services-package-deployment.html

youtube.com

SSIS 2008 Series: SSIS Package Deployment part1/2

https://www.youtube.com/watch?v=YXJ2lplvA28

Now researching what types of permissions I...