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?

[Webinar] Streamline your web hosting managementRegister Today

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
All Courses

From novice to tech pro — start learning today.