There is no technical restriction preventing an SSIS package from pushing from a developer edition to an web edition but there is likely a legal restriction for doing so. You might think that you can make an end-around and run the SSIS package from the development server but that will likely violate your license as the dev license is not supposed to communicate with production systems. There is the import/export wizard which builds an SSIS package but if you persist it and execute the package, then it will fail as the machine will report it does not have the right components installed. The Web edition is not licensed for Integration Services. That pesky asterisk though, that might be make this a No answer. It will be a straight data transfer between two SQL Server instances. Yes *, you can create an SSIS package in the Developer Edition and it will transfer data between the developer edition database and the web edition just fine.
0 Comments
Leave a Reply. |