Solved

Running SSIS package on remote server outside of domain

Posted on 2013-05-29
1
491 Views
Last Modified: 2016-02-10
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?
0
Comment
Question by:bruskhickory
1 Comment
 
LVL 1

Accepted Solution

by:
jonimatix earned 500 total points
ID: 39207470
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

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now