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?