Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Running SSIS package on remote server outside of domain

Posted on 2013-05-29
1
Medium Priority
?
500 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 1

Accepted Solution

by:
jonimatix earned 2000 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
Here's a requirements document template for an integration project (also known as Extract-Transform-Load or ETL) based on my development experience as an SQL Server Information Services (SSIS) developer over the years.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

715 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