earwig75
asked on
How can I copy data from one server/table to another server/table using SSIS
I am not looking for a very technical answer to this, just the basics of what I need to put into my Control Flow/Data Flow. I don't use SSIS often, so I forget how to do this. I want to run a query against one server, and then take those results and insert them into another server/table. Can someone assist?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Would I use the Execute SQL Task? I have an SQL task with my query in it, but I need to write those results to a table on a different server. I have the connection managers set up, I'm just not sure how to get it from the SQL query, into a destination table.
Just used drived column tool
ASKER
I don't want to copy all data from one place to another, only the results of a query.
Is this something you will be doing on a schedule, or do you just need to copy the data once?
ASKER
I will be doing it on a schedule. I think I figured out that I can just put a query in the data source without an sql task.
Yes, just create a T-SQL job step containing the query, if you are doing a simple copy between tables or databases on the same server. SSIS comes in when you go between servers, or have a lot of tables to copy.
For simple table-to-table copies with SSIS, I just use the import/export wizard. It can copy one table or many, on one server or between servers. It creates a package, but I don't normally save it.
For simple table-to-table copies with SSIS, I just use the import/export wizard. It can copy one table or many, on one server or between servers. It creates a package, but I don't normally save it.
Please follow below link that explain .
https://dba.stackexchange.com/questions/25867/moving-data-from-one-db-to-another-using-ssis