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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.