Link to home
Create AccountLog in
Avatar of Tyecom
TyecomFlag for United States of America

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
Avatar of Chris Mangus
Chris Mangus
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of Tyecom

ASKER

Thank you for responding.  In addition to the above question, is any additional software needed on the destination (remote) computer?  Does the destination computer requirement BIDS installed on it also?  
No, you don't need BIDS installed but you do need Integration Services installed.
Avatar of Tyecom

ASKER

Answered question, however, I was looking for a little more details.  Still grateful for answering my question.  Thanks