Running SSIS package on remote server outside of domain

Hi am new to SSIS and I have to create an ETL package. I would like to know if its possible to create an SSIS package on my local server and then copy that package to another server outside our domain?
The outside server has SQL Server 2008 R2. What I have to do is get a .csv file and make some transformations e.g. change data into correct format and then export out again to a .csv file.
Can this all be done by running the deployment executable?
If not are there other ETL tools which are cheap or free which I could do the same thing?
bruskhickoryAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jonimatixConnect With a Mentor Commented:
Yes you can use the same ssis package as long as you would modify the connection string of the csv file and database connection. You should not have a problem
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.