We help IT Professionals succeed at work.

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.
Comment
Watch Question

Database Administrator
CERTIFIED EXPERT
Commented:
No, they don't have to be rebuilt they just have to be deployed to the remote server.  That is, unless your connection strings inside the SSIS packages need to be changed.
TyecomSr. Systems Analyst

Author

Commented:
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?  
Chris MangusDatabase Administrator
CERTIFIED EXPERT

Commented:
No, you don't need BIDS installed but you do need Integration Services installed.
TyecomSr. Systems Analyst

Author

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

Explore More ContentExplore courses, solutions, and other research materials related to this topic.