• Ok I think I have answered my question, have been looking around and I found the below link:

    https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx

    So, I assume if I had a standard instance, and tried to deploy a package to it using some of the enterprise SSIS features (like the advanced connectors), then it wouldn't work, but if I restrict myself to functions that are part of the SQL server enterprise database (like table partitioning) then it would be fine, as there are no restrictions there.