Kevin
SQL Server (the database engine) doesn't have to be installed. However, you will need to install the SSIS full client (from the SQL Server installation media) and have a valid SQL Server license for that machine.|||
What Phil said is true that you can do this, however, there are other considerations on why you may not want to.
One main reason is if you are moving large amount of data through SSIS. If you have it on a seperate machine:
[Source Machine] - - - large amount of data - - > [SSIS machine] - - - large amoutn of data - - > [destination machine]
VS
[Source Machine] - - - large amount of data - - > [SSIS/Desitination machine]
As you can see, you will be moving large sets of data accross your network twice.
No comments:
Post a Comment