Tyecom
asked on
Exporting SSIS Packages To Remote Server
I have some SSIS packages that were created to replace some old DTS packages that were created under SQL 2000. We are in the process of upgrading this server to Windows Server 8 R2 and MS SQL 2008. This particular server is a remote server that I have access to. My question is...I created these SSIS packages on a local machine, after we've completed our upgrade, what is the best way to export, run, etc. these package against the tables on the remote server. Do I have to rebuild these packages on the remote server? Thank you in advance.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
No, you don't need BIDS installed but you do need Integration Services installed.
ASKER
Answered question, however, I was looking for a little more details. Still grateful for answering my question. Thanks
ASKER