We have an application that needs SSIS on the application server to upload data to our SQL database server which runs enterprise edition. Do I need to install the same editon of SSIS on the application server? Can SQL 2005 Standard editon SSIS communicate with the Enterprise Edition? Thanks.
Yes, you can use any SQL Server edition that includes an SSIS license on your application server.|||
isd83 wrote:
We have an application that needs SSIS on the application server to upload data to our SQL database server which runs enterprise edition. Do I need to install the same editon of SSIS on the application server? Can SQL 2005 Standard editon SSIS communicate with the Enterprise Edition? Thanks.
Yep, the standard or enterprise versions of SQL Server are required. Either will work in this case.
|||Thank you Phil and JayH for you help.
No comments:
Post a Comment